VERIFIED SOLUTION i

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


 

Issue

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"
 

Cause

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.

Resolution

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.