getting the system date format with vba

[thread]

Hi is it posible to get the format of the system for the date via vba?

i'm working with users in several of places and the format is
changing
or
DD/MM/YYYY
or
MM/DD/YYYY
i need to get the computer format in order to make the macro to work ok

 

[Allen Browne]

See:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

The article explains what format you need to use in which contexts
(interface verses code/SQL statement), and how to avoid the 3 cases where
Access can misunderstand your dates.