Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

getting the system date format with vba

 
   Database Help (Home) -> MS Access RSS
Next:  Ordering certain entries in a range, matched agai..  
Author Message
thread

External


Since: Nov 26, 2007
Posts: 51



(Msg. 1) Posted: Tue Dec 02, 2008 5:06 am
Post subject: getting the system date format with vba
Archived from groups: microsoft>public>access (more info?)

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

 >> Stay informed about: getting the system date format with vba 
Back to top
Login to vote
Allen Browne1

External


Since: Apr 03, 2004
Posts: 1554



(Msg. 2) Posted: Tue Dec 02, 2008 9:33 am
Post subject: Re: getting the system date format with vba [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

 >> Stay informed about: getting the system date format with vba 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
converting general date format data into short date format - hello, i am doing a date comparation and i have reallize that the data i have in my database (general date format) it is causing me problems, and because i donīt need the time data i would like to convert all the general date data into short date format...

Using "MM" Date Format in Query When Data is "M" format - I'm thinking this is easy but can't get it. I have a table with following: Table1 Date 1/1/2007 Table2 Type 0107 (This is MMYY of above) So I'm having trouble using a query to turn the date from Table 1 into the Type from Table 2. I know when the..

date format - Hi folks I have a large database which has various fields with dates held in numerical format. I would like days to be shown in mail merge documents as, eg 1st 22nd 3rd, etc. and have tried using the pattern "Dte"\@ "dddd, d MMMM, yyy...

How do I format a date? - In designing a table record to return a date, but only the month/day, how do I do that? Do I enter it under format or input mask and what do I enter? -- Rich D Armstrong Custom Homes Redmond

Date format - Good afternoon: I have a field "ship date" in a table that is populated as follow "05JAN2006" (DDMMMYYYY) and this field is a text field. I would like to turn this field into a date field where I could make calculations and REALLY...
   Database Help (Home) -> MS Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]