Home > Articles > Details

Sql Server Error: Unable to modify table.   The conversion of a date data type to a datetime data type resulted in an out-of-range value. The statement has been terminated


Question: How do you resolve "'YourTableName' table
- Unable to modify table.  
The conversion of a date data type to a datetime data type resulted in an out-of-range value.
The statement has been terminated."

Solution: Warning! this solution should not be performed on a production Server, assuming this error happens on your local Development Machine. 
1. Recreate or create a new column that has the Data type Conversion Problems.


If you log in, you will be notified when someone leaves a comment.

Other users would like to know if this solution helped you.


© 2022 - ErnesTech - Privacy