Access Date conversion

  • Thread starter Thread starter Argus
  • Start date Start date
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?
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Convert EML to PST files? 1
EML to PST Converter Software to Convert EML Files to PST 0
How to easily migrate PST to Zoho account? 2
How to convert OST to PDF? Simple Methods 4
Julian Date Conversion 12
How can I convert MBOX to MSG in Bulk with attachments? 2
Date format with input masks 2
Import text file data conversion problem in Access07 2

Back
Top