Link to home
Create AccountLog in
Avatar of gcgcit
gcgcit

asked on

Migrating dates in different formats

I have an access database that has a date field formated "mm/dd/yyy" but I'm going to be importing it into a field that is formatted "yyyy/mm/dd".

Will I need to do anything special on the import to ensure the data doesn't get messed up when I import it?
ASKER CERTIFIED SOLUTION
Avatar of JAMcDo
JAMcDo
Flag of Canada 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
Avatar of gcgcit
gcgcit

ASKER

Giving you both points, more to JAMcDo since he answered first.  2nd opinion always helps though.  Thanks experts!