Importing data - problem with changing date format!

[highlystrung]

Hi, I'm importing data using a piece of code as shown below. However, when it's imported (using "MasterProcedurePhaseOne") the data format is changed from dd/mm/yyyy to mm/dd/yyyy so it is incorrect. Can anyone advise how I make it work correctly? thanks, Neil

I've attached the file I am importing to (Importing File) and the one I am importing from (Data to Import).

The code I"m using is as follows:

Please Login or Register  to view this content.

[highlystrung]

I've just found out that it is because I"m using a CSV file to import the data from - the issue doesn't occur when I use the file as an XLSX file! Hence it won't show up as a problem in the file I've loaded! Hence, I have a solution, change the original file to an XLSX file. However, I'd still like to know why it happens with a CSV file.... if anyone can advise....?