Hey all,

I have a spreadsheet that is sent to me with columns that have dates. However, these dates are in european format ( dd/mm/yyyy ). My settings are US, so its attempting to convert any with dd > 12 over to the mm/dd/yyyy format.

So, my problem is, all of my tables are in US format obviously. and thus comparing the dates is not working. So far I've just been doing a manual update query on the columns each day that I'm sent the spreadsheet.

Code:
Format([myDate],"dd/mm/yyyy")
This will actually flip-flop the numbers around for me into being in the US format. This is not an ideal solution for me though, as this all needs to be automated.

I've searched a bit and haven't found anything that I can use just within a query (MS ACCESS) to either convert the dates to US format, OR if i can just temporarily format them when comparing to my other tables.

Any suggestions or ideas?

Thanks,