getting the system date format with vba

T

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
 
A

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.
 
Top