Help!

Date Format for Australia

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Getting Started RSS
Next:  Time Date Query  
Author Message
sive
External


Since: Mar 15, 2007
Posts: 7



PostPosted: Sun Mar 18, 2007 7:42 pm    Post subject: Date Format for Australia
Archived from groups: microsoft>public>access>gettingstarted (more info?)

Hi there. I have set the language settings to English (Australia) for MS
Office, however when I try to enter a date into a table as 21/3/07 (this is
how dates are generally used in Australia ie day/month/year ), it will
default to: 3/7/2021. Can someone please advise how to make sure that a user
can enter a date as 21/3/07 and that it appears in the table date in this
way, and stores in this format.
Thank you
Back to top
Douglas J. Steele
External


Since: Oct 07, 2003
Posts: 8178



PostPosted: Sun Mar 18, 2007 11:29 pm    Post subject: Re: Date Format for Australia [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Take a look at what your fellow countryman Allen Browne has in
"International Dates in Access" at http://allenbrowne.com/ser-36.html

You might also check what I have in my September 2003 Access Answers column
for Pinnacle Publication's "Smart Access" newsletter. (The column and
accompanying database can be downloaded for free at
http://www.accessmvp.com/djsteele/SmartAccess.html)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"sive" wrote in message

> Hi there. I have set the language settings to English (Australia) for MS
> Office, however when I try to enter a date into a table as 21/3/07 (this
> is
> how dates are generally used in Australia ie day/month/year ), it will
> default to: 3/7/2021. Can someone please advise how to make sure that a
> user
> can enter a date as 21/3/07 and that it appears in the table date in this
> way, and stores in this format.
> Thank you
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Getting Started All times are: Eastern Time (US & Canada)
Page 1 of 1

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