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

Created by Cheng Kah Poh, Modified on Tue, 10 Nov, 2020 at 4:10 PM by Cheng Kah Poh

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.