Replacing old 2 digit year in date fields

[Denis]

Is there a quick way to rpelace old dates that are entered as 8/12/00 and result in a 1900 year? I have tried calculations to get the year and need to replace the 00 with 2000. Any advise?

[Chuck]

Use the Replace option in the Records menu and replace with a calculation set to the following:

Case(

[Denis]

Thanks Chuck, I did try the follwoing with a replace that I saw in one of your other esponse and it worked also, but I think your newest will work beter. Thanks again.

New Date=

Date( Month( DATE PAID ) , Day( DATE PAID ), "2000" )