Start a conversation

The conversion of the varchar data type into datetime produced an out of range value

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.

  1. Go to Security -> Logins
    1. Find the user that is used for the TmMaster v2 Connection StringRight 
  2. Click -> Properties
    1. 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.

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Emma - TM Support

  2. Posted
  3. Updated

Comments