UK Date Format In Linked Table ("dd/mm/yyyy")

[smoothlarryhughes]

Hello,

I am having trouble with linking a table with a text field with a date in the format "dd/mm/yyyy." If the day is larger than 12 access knows it is a day, and lets me format it by using an expression of format([date],"mm/dd/yyyy") however if the day is 12 or smaller it thinks the date is in us format.

Example.

Excel linked file has a date of 17/06/2013 and formats it properly on my query to 06/17/2013, but another field has a date of 05/06/2013, and the query gives back 05/06/2013, when it should be 06/05/2013. Any ideas?

Thanks!

Jim

[June7]

Does this help http://allenbrowne.com/ser-36.html