I have 5000 records with dates from 1996-2001. Unfortunately the dates past 1999 came out as 1900 and 1901. I want to change this to 2000 and 2001. The date format is M/D/Y. I tried exporting as text and doing a find/replace on

/1900 to /2000

but this somehow messed up the records when I reimported. Is there a way I can split the date apart, fix the year and then put them back together again?

Any suggestions would very much be appreciated.

First, back up the file before doing this. If something goes wrong, your backup will be the only way to fix it.

Assuming that your date field is called My_Date, find all of the records and go to a layout that has the field on it, and click into the My_Date field. Choose Replace from the Records menu, select "Replace with calculated result:" and enter the following equation into the calculation:

Case(