Tools
Rss Categories

Error converting data type nvarchar to datetime

Views: 636 Created: 2016-08-04 12:27 Last Updated: 2016-08-12 08:31

SYMPTOM

The following error message displays at random when the program is running or when trying to save a transaction:

"Error converting data type nvarchar to datetime".

CAUSE

The Windows Date Format is set incorrectly.

RESOLUTION

Procedure 1 (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.

APPLIES TO

  • WinFiler 2012 - 2013
  • WinFiler Plus 2013
  • Yearli 2014 - Current