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
 
Ad

Advertisements

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

Text to date format? 0
Input Masks 2
Date format when exporting 2
Form Control Calendar date will not change its format 1
access, date field 1
Access VBA - date format conversion 4
Stored date is not being recognised 1
FILTERING A FORM WITH A DATE 3

Top