Date format changes

cpurpleturtle · Jun 25, 2008

Hello. I have a subform where the user has to enter a date in one of the
table columns. I have the format set to dd/mm/yyyy because it is being used
in India. When I enter some dates, it automatically changes it. Here are
some examples of what it is doing. How do I stop it from doing that?

Enter 5/10/2008 and it changes to 10/5/2008
Enter 07/16/2008 and it changes to 16/07/2008
Enter 16/07/2008 and it stays the same

Douglas J. Steele · Jun 25, 2008

Check Allen Browne's "International Dates in Access" at
http://allenbrowne.com/ser-36.html or what I had 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)

Forcing a date entry format of dd/mm/yyyy	1	Jan 18, 2014
Date field not stay in same format	1	Mar 5, 2008
Changing mm/dd/yy format to mm/dd/yyyy	1	Jul 16, 2008
Finding Totals from two diff date ranges	5	Sep 17, 2009
Access 2003 Date Input problem	3	Jun 12, 2009
HELP WITH DATE EXPRESSION	2	Jul 3, 2008
Default Date in forms...	5	Jun 4, 2008
Filtering on a series of Dates via a combo box	3	Aug 6, 2008

Date format changes

cpurpleturtle

Douglas J. Steele

Ask a Question

Similar Threads