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.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"thread" wrote in message
> 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