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.