Data Manager: Dates coming out wrong in a csv

JohnMR · June 16, 2017 9:58AM

Hi all,
I've created a file that has dates info. When I pull the dates in the UK format (dd/MM/yyyy) everything is fine but if I use the field organiser to change to US format (MM/dd/yyyy) the csv date column is half in dates (if you use show formula it's a number like 42045) but half is no dates (if you go to show formulas it's 02/10/2015). Why is this happening? It doesn't happen if I use UK dates.
Thanks,
John.

chris · June 16, 2017 10:56AM

Hi John,

Thanks for the question. Can you post a sample of the CSV file?

Thanks

Chris

chris · June 16, 2017 10:56AM

Also can you let us know what version of Omniscope you are using.

daniel · June 18, 2017 2:58AM

That may actually be a setting in Excel auto-converting your csv file if you are opening it in there, check the same file in notepad as well.

Welcome!

Categories

Ideas Parade

Tagged