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.

  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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article