Day & Month swapped around

[bobmac-]

Hi,

I have a date value being taken from an android tablet which had it stored in a CSV file. The CSV file is opened with EXCEL and saved as an XLSX file.
When I use VBA to read in the value to an ACCESS table the month & day is reversed. What is the easiest way to fix this in VBA?

Cheers

 

[bobmac-]

I should have remembered this. I'm using SQL INSERT so I have to make sure the date part of the string is in americain format. Problem solved