getting the system date format with vba

  • Thread starter Thread starter thread
  • Start date Start date
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
 
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

printing report with date 3
Text to date format? 0
Date format when exporting 2
Access VBA - date format conversion 4
FILTERING A FORM WITH A DATE 3
Date Formatting 1
access, date field 1
Input Masks 2

Back
Top