5000 records, wrong year. How do I fix?

[jrs320]

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.

[Chuck]

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(