Troubleshooting: Save Transaction Error - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

From AutoCount Resource Center

Question: When I save Invoice, this message prompted “SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.” Why?

Version: 1.8 / 1.9 / 2.0


Possible Reason:

Suspect a date column was input with invalid date which is out of 1/1/1753 – 12/31/9999.

Example field: Our P/O Date.


Solution:

Find out the incorrect date and correct it.
Then you should be able to save the transaction.


Note: Please make sure all workstation and Server computers are having updated date and time too.


By: Lay Swan 220527, P220627


Go to menu

AutoCount Accounting 2.0 & 2.1


AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS


AutoCount On The Go
AutoCount Accounting Plug-In Documentations