Link to home
Create AccountLog in
Avatar of farmingtonis
farmingtonis

asked on

Convert text based date (01/01/01) to date format in Access

Hi -

We import an excel sheet into Access on a daily basis.  One of the fields is a date field but comes in as text.

The format is:

mm/dd/yy

The problem we have is that it spans both the 1900s and 2000s year spaces.  

So, if we get a date that looks like this;

01/01/02 - we are pretty confident it is 2002

but if we get on that looks like this;

01/01/96 - we are pretty confident it is 1996.

However, I don't know how to translate what I know to telling Access how to figure it out.

Any suggestions?

Thanks,
SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of farmingtonis
farmingtonis

ASKER

They all work great.  thanks.