Jump to content

Date Import Error


This topic is 5684 days old. Please don't post here. Open a new topic instead.

Recommended Posts

We received a text file with dates formatted mm/dd/yyyy and imported it into our hosted file but the dates got messed up.

5/8/06 became 8/5/06 with the month and day switching positions.

It only seems to have switched dates with days under than 13 as the date 3/16/2006 imported fine.

My thoughts are that it has to do with the File Options -> Text Settings. Here you have the option to use System Setting or File Saved Settings. I am not sure what the user settings were when the data was imported so this may have caused the switch.

Is there some way to tell what the hosted files saved settings are to see if it is set to dd/mm/yyyy instead of mm/dd/yyyy? And if the file's saved settings are dd/mm/yyyy how can you change the saved settings to always use mm/dd/yyyy?

Thanks for your thoughts,

Steve

Link to comment
Share on other sites

This topic is 5684 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.