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 dropping a student from a class

When your date format in Regional and Language settings is set to dd/MM/yyyy, users may receive the following error when dropping a student from a class and deleting the course request: 

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 [Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated. Native error:3621
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

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

OR

Change the short date format in Region and Language setting to MM/dd/yyyy.

Environment

 7.82.104, patch 31
 7.82.104, patch 34 ; 7.86.93

Was this article helpful?