Error converting data type nvarchar to datetime

The Windows Date Format is set incorrectly.

Verify Regional Settings

  1. Access the Windows Run window by pressing the Windows key and R key on the keyboard.
  2. Type "intl.cpl" without the quotes in the Open field.
  3. Click OK.
  4. In Windows 7, 8 and 10, click Additional settings...
  5. In Windows Vista, click Customize this format...
  6. In the Date tab: 
    1. Verify that Short date is set to "m/d/yyyy".
    2. Verify that Long date is set to "dddd, mmmm dd, yyyy".
  7. Click OK.
Was this article helpful?
0 out of 0 found this helpful