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.