Hi Bob
Sorry. This is when we view the CSV in Excel. I am actually thinking that this maybe an issue with excel.
I am being given a CSV file.
I open it in excel and the dates are dd/mm/yyyy
I reformat dates to yyyy-mm-dd
when I save I get the contains formatting error that happens on every csv in the world I think.
When I relook in excel the date revert to dd/mm/yyyy
however if I look at the CSV in notepad they are the yyyy-mm-dd format
so I am wondering if excel is changing this information.
|