TM Master Common Errors
The conversion of the varchar data type into datetime produced an out of range value Spanish/Portugese Date Format
Infotech.Data.DataComponents.DataCompException: The conversion of the varchar data type into datetime produced an out of range value. ---> System.Data.SqlClient.SqlException: The conversion of the varchar data type into datetime produced an out of range value.
This is an issue where the a default Spanish/Portuguese Date format is conflicting with the ISO Standard. (Some Spanish/Portuguese date formats are YYYY-DD-MM and are in conflict with the international standard YYYY-MM-DD)
One solution, is to go to SQL Studio Manager.
- Go to Security -> Logins
- Find the user that is used for the TmMaster v2 Connection StringRight
- Click -> Properties
- Set the Default Language for the user to English. This doesn't really change anything for the user of TmMaster V2, but it can fix this issue.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article