Date input format

[Samuel]

Hi

When I enter 01/02/2006 the system assumes that it means 02/Jan/2006 only
when I enter 22/06/2006 the system reads dd/mm/yyyy.

How can I make sure it reads the day first regardless

Thank you,
Samuel

 

[Jeff Boyce]

Samuel

I believe that's a Windows setting...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Allen Browne]

See:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html
for an explanation of how Access treats dates, and what you can and cannot
do to address this issue.