I am located in NY and recently received two files from London.
One has the dates transformed properly, although in dd-mmm-yy format.
The other one has the day and month reversed, so what should be Dec-1-03 is now 12-Jan-03. The ones with the day > 12 get formatted as text.
Does anyone have an idea why this is happening on one file and not on the other?