European Date Format

[Angus]

Hi,

I am trying to get a european date format in a for. My
regional setting are set to Australia and I have set the
format to "short date" with the imput mask as "99/99/00".

When I enter the date "20/09/04" the date "04/09/20"
appears.

Any help would be appreciated.

Thanks,

Angus

 

[Allen Browne]

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

The article comes out of 11 years experience developing in Access is
Australia.

BTW, the input mask does no good.