[RESOLVED] Date formatting

[ice_531]

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.

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,

[ice_531]

I will mark this as resolved for now. I have come up with a solution for now.

Just added a query into my automation macro, that links primary keys from the original table and then the return table, and i just overwrite the dates in the return table with those from the original.

Works fine for what i need it to do. I am still interested in how to deal with local region settings that excel/access both format to. Not sure how you deal with that while in Date format, other than changing the data type to string so that it doesnt get changed.