Date Localization Problem

[Samuel]

When I send the database the following value 15/06/06 it assumes it is
15/June/2006 and that is OK but when I send 01/07/06 referring to 01/July/06
it assumes it is 07/Jan/06 (I am based in the UK)

What can be done to solve this problem?

Thank you,
Samuel

 

[Douglas J. Steele]

Take a look at Allen Browne's "International Dates in Access" at
http://allenbrowne.com/ser-36.html or what I had in my September 2003 Access
Answers column for Pinnacle Publication's "Smart Access" newsletter. (The
column and accompanying database can be downloaded for free at
http://www.accessmvp.com/djsteele/SmartAccess.html)