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?
Who is Participating?

Improve company productivity with a Business Account.Sign Up

JAMcDoConnect With a Mentor Commented:
I think that the date format of the target will take care of the change of date format.

MINDSUPERBConnect With a Mentor Commented:
I go with  JAMcDo. The Date format doesn't affect the value of the date so I don't see any issue when you do the import/export.


gcgcitAuthor Commented:
Giving you both points, more to JAMcDo since he answered first.  2nd opinion always helps though.  Thanks experts!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.