Error: General ODBC Error:[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of range value. Native error: 242

Error: General ODBC Error:[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of range value. Native error: 242 when running Statement of Activities report

Download and install the latest version and patch, if applicable. 

Workaround: Change Regional Settings to English (United States) with date format as mm/dd/yyyy.

Environment

 7.84.52, patch 3
 7.87.164

Was this article helpful?