Date field not stay in same format

K

Kyle

I have a Due Date field in my form. I noticed the date not stay in the
format I want dd/mm/yyyy. it keep change back to mm/dd/yyyy when user enter
22/03/2008 ==> 03/22/2008. How do I make the date stay as dd/mm/yyyy. As
long as the day is below 12, then the format stay as 12/03/2008 (dd/mm/yyyy).

Any help to correct this problem is appreciated.

Thanks.
 
A

Allen Browne

Access displays dates in the format you specified for your regional
settings. Go to Regional Options in the Windows Control Panel to define your
date format.

For details, see:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

If you have entered the dates thinking one thing, but Access interpreted
them as something different, you may need to go back and correct these
entries.
 

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

How to use/create code in MS Word to calculate age? 0
VBA - exporting serial letters to single documents 0
How to add day to PWA 2016 date format? 0
Forcing a date entry format of dd/mm/yyyy 1
Converting Birth Date format 1
Date Formats 4
Date Maniplation 1
Publisher is filling blank lines with data 2

Top