detecting date style

message from Dave on 5 May 2004
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 replied to Dave on 5 May 2004
Hi Dave.

International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html
 
Terry Kreft replied to Dave on 5 May 2004
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.
 

Archived message: detecting date style (Microsoft Access Forms)