Date Import Error

[Squeaky Data]

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

[comment]

This has been have covered several times. I'd suggest you do a search for:

+OS +settings +clone

and my username. If none of these answer your question, ask more.