Resolve Invalid datetime format error on executing Street Work Reports in Confirm



Invalid 'datetime' error is received when Street Works Report is executed in Confirm. This error is specifically received when either or both Notice Type and Work Status are selected to execute the report. The error that is thrown while executing reports is "sqlstate = 22007 [oracle][odbc]invalid datetime format"


This is a known issue to the Microsoft. Cause, as mentioned in the article by Microsoft mentions an error in the algorithm that converts the date/time is not rolling the hours portion of the time over to the days portion of the date.


UPDATED: March 29, 2017
Refer the article "FIX: Error Message "Invalid Time Format" published by Microsoft.

If the issue is still not resolved, contact client support.