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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query problem 1
Date problem 3
Access 2002 date format 3
Problems with dates in Access programming in C++ 2
How do I convert a text value to a date in MS Access 97 2
-> Dates are getting reversed <- 3
detecting date style 2
Formating a Date 1

Top