(Optimum) Upgrade database prompted Bank Reconciliation error SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. : QNE Software Sdn. Bhd.

(Optimum) Upgrade database prompted Bank Reconciliation error SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. Print

Created by: Cheng Kah Poh

Modified on: Tue, 10 Nov, 2020 at 4:10 PM

Solution:

1. Login database and ignore database upgrade.

2. Go to Tools > Database Utility > Database Util.

3. Connect to database and execute below script.

select * from bankreconciliation where cleardate < '1753-01-01' or entrydate < '1753-01-01'

4. Based on the result, go back to Bank Reconciliation and correct the Clear date

5. After correct all the clear date, you may re-login to upgrade database.

Cheng is the author of this solution article.

Did you find it helpful? Yes No

Help Desk Software by Freshdesk