Message load failed due to : The conversion of a varchar data type to a datetime....Failed Registration: Unable to execute update tbl_master ...date installed dd/mm/yy

Error Message Displayed:

message load failed due to:The conversion of a varchar data type to a datetime data type resulted in an out-of-rage value:

Check regional language setting and make sure that the Formats/Current Format is set to English (United States) and that the Short Date is set to  M/d/yyy and the Long Date is set to dddd,MMMMdd,yyy.  

1.       Click the Start button, and then click Control Panel.

2.       Click Clock, Language, and Region, and then click Regional and Language Options.

3.       The Regional and Language Options dialog box appears.

4.       On the Formats tab, under Current format, click Customize this format.

5.       The Customize Regional Options dialog box appears.

6.       Click the tab that contains the settings that you want to modify, and make your changes. For example, to change part or all of a number format, click the Numbers tab and change the setting that you want.