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?
Will I need to do anything special on the import to ensure the data doesn't get messed up when I import it?
Microsoft Access
Last Comment
gcgcit
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Giving you both points, more to JAMcDo since he answered first. 2nd opinion always helps though. Thanks experts!