Changing the century part of the date.

[Chet]

I receive Excel files that were downloaded from QuickBooks. They use a date such as: 03/05/28. Any date that falls below 1930 it defaults to the next century. So I get it as 03/05/2028. I simply want to subtract 100 years from the year if the year is greater than 1999. I want to update the field using an update querry. Here's how I see it.



If the DOB is greater than #12/31/1999# subtract 100 from the year.

I cannot seem to get the coding right. I've search for examples. Tried several combinations of critera. Any help would be appreciated. Thanks

[June7]

Try this in the UpdateTo row of query:
IIf([DOB]>#12/31/1999#, DateAdd("yyyy",-100,[DOB]),[DOB])

[Chet]

I could not leave without saying Thanks a ton for being there!!!!
Chet