Regardless of what your Short Date format has been set to in Regional
Settings, you MUST use either mm/dd/yyyy or an unambiguous format such as dd
mmm yyyy or yyyy-mm-dd.
You may want to read "International Dates in Access", by Allen Browne, at
~allenbrowne/ser-36.html or what I have in my
September, 2003 Smart Access column at