Access Date conversion

A

Argus

I have imported files from an old DOS program that is not Y2k compliant. How
can I convert all date fields that start with the 1900 prefix to 2000?

Is there a formula I can use?
 
J

Jeff Boyce

Argus

"date fields" is a bit ambiguous...

Do you mean you have text strings that look like dates? For example:

"19010401"
"1901-04-01"
"April 1, 1901"
...

Or do you mean you have values that are of type Date/Time in Access (stored
as Doubles)?

"How" depends on "what"...

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jake

If you imported data was two digits

e.g. 08 was supposed to be 2008 and imported as 1908

Create an update query adding 100 years to each date.
 
Top