Log in

View Full Version : Access: Date Format using slashes but america dates come up


missmarple
Feb 21, 2008, 04:12 PM
I want for e.g.. 02/11/07 applied to my dates. ( 2nd November 07)
How do I customise it. Help appreciated using slashes and days before month

this8384
Feb 21, 2008, 05:03 PM
... what?

What are you trying to customize?

missmarple
Feb 22, 2008, 10:44 AM
Hellow
I want the date formatted using slashes. Exmple for 2nd November 2007 as 02/11/07
I have tried using Date/Time iin the drop down list and selecting the slash es automatically will come up as 11/02/07 which is not what I entered. Does that make sense?

this8384
Feb 22, 2008, 10:55 AM
You're not telling me what it is you're trying to customize.

missmarple
Feb 22, 2008, 11:56 AM
Sorry about that.
Creating a Table with a Date label. . In design view in Tables I selected drop down data type and selected date/Time Data Type instead of text. Then I want to enter date as 02/11/07 but it comes up as 11/02/07.. I want 2nd Nevember 07 in this format 02/11/07

ScottGem
Feb 29, 2008, 07:29 AM
Date formats are set by your Regional Settings in Windows.

missmarple
Feb 29, 2008, 01:23 PM
Thanks, ScottGem. Got it.