detecting date style

[Dave]

How can i detect the date style that the users system is using.

I have some customers that have dd/mm/yy and some that have dd/mm/yyyy

I have a input mask (99/99/00;0;_) that is set for dd/mm/yy.

Is it possible to check what format the system uses and then dynamically
alter
the input mask in the OnOpen Event

thanks
Dave

 

[Allen Browne]

Hi Dave.

We have found input masks are worthless for sorting out date issues.
Our experience with 11 years of handling dd/mm/yy dates is in this article:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

 

[Terry Kreft]

Look at

http://www.mvps.org/access/api/api0017.htm

to get the short date format you would make the following call

fLocaleInfo(LOCALE_SSHORTDATE)

but have a look at Allen's reference as well.