Experts, I have a problem that is driving me cross-eyed.
I have a csv file called TN0001.csv (attached).
Column A is "Date"
. Format is dd/mm/yyyy
Date range is 14/04/2013 - 12/05/2013
When I open the file from explorer in the normal way, it is absolutely fine.
All the dates are in the correct format
HOWEVER, when the file is opened from within a routine:
the formatting of the dates is inconsistent. I.E.
All the April
dates are correctly formatted: 14/04/2013
BUT, all the May
dates are the wrong way round. I.E. 05/12/2013
instead of 12/05/2013
I have tried changing the directory. I have tried runnning it on different computers.
I cannot for the life of me fathom out why number date formats should change because a file is being opened with code, instead of a mouse!
I have attached a separate file showing the different formats.
Please, Please, can someone help?