Insert Date Error

[Gary]

hi

I'm having difficulty with an insert query in MS Access
2000 on an NT4 machine.

When a date is inserted and the day value is smaller than
the month value it swops the day and month values.

 

[Allen Browne]

Hi Gary

See:
International Date Formats in Access
at:
http://members.iinet.net.au/~allenbrowne/ser-36.html

The article explains how dates entered in the user interface use the format
set in the Windows Control Panel under Regional Settings, but literal dates
in VBA code or SQL clauses must be entered in mm/dd/yyyy format.