Adjust Latest Schedule Start Date by one second only if it is set to midnight 00:00:00

Idea created by Chi_Chen Employee on May 25, 2016
    Not planned
    Score5
    • Nabeel1
    • bemerson
    • Chi_Chen
    • tzadell
    • Brian.Sheppard.FirstData

    When search change orders and set the Latest Schedule Start Date to midnight 00:00:00(or 12:00 am), SDM changes it to

    23:59:59(about a day later). For example you want to search all change orders that have schedule start date between 5/11/2016 00:00:00

    and 5/12/2016 00:00:00 by set the Earliest Start Schedule Date as 5/11/2016 00:00:00 and Latest Schedule Start Date as 5/12/2016 00:00:00,

    SDM changes the Latest Schedule Start Date to 5/12/2016 23:59:59. As a result, the search returns 2 days(almost) data instead of one day's

    data that you wanted to search.

    Suggestion: instead of set to 5/12/2016 23:59:59, set it to 5/12/2016 00:00:01 or 5/11/2016 23:59:59