where clause uk date problem

[Shaft]

How can I convert a UK Date to a US date in code because for some unknown reason all date literals in a where clause, regardless of where you come from must be in US format.

Any help would be much appreicated?

 

[RuralGuy]

You need to use the Format() function.

Here's a link:

http://www.mvps.org/access/datetime/date0005.htm
Date/Time: Return Dates in US #mm/dd/yyyy# format