Ask Experts Questions for FREE Help !
Ask
    missmarple's Avatar
    missmarple Posts: 52, Reputation: 1
    Junior Member
    		  
    #1

    Feb 21, 2008, 04:12 PM
    Access: Date Format using slashes but america dates come up
    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's Avatar
    this8384 Posts: 4,564, Reputation: 485
    Ultra Member
    		  
    #2

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

    What are you trying to customize?
    missmarple's Avatar
    missmarple Posts: 52, Reputation: 1
    Junior Member
    		  
    #3

    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's Avatar
    this8384 Posts: 4,564, Reputation: 485
    Ultra Member
    		  
    #4

    Feb 22, 2008, 10:55 AM
    You're not telling me what it is you're trying to customize.
    missmarple's Avatar
    missmarple Posts: 52, Reputation: 1
    Junior Member
    		  
    #5

    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's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #6

    Feb 29, 2008, 07:29 AM
    Date formats are set by your Regional Settings in Windows.
    missmarple's Avatar
    missmarple Posts: 52, Reputation: 1
    Junior Member
    		  
    #7

    Feb 29, 2008, 01:23 PM
    Thanks, ScottGem. Got it.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

SAS code to Format decimal places and julian date [ 2 Answers ]

I am working with a data set that I would like to link with another data set. However, I need to do two thing before linking the two data set together. One is that I have a variable claim that I need to format. The variable has values 250, 5525 etc and I need to place a period to make it 2.50,...

Converting an mdb (Access 2000) to exe format [ 2 Answers ]

Hi, I'm working on a database and would like to lock the access to the tables and queries. I was told that the best way to go about it is to convert the mdb file into an exe file. The question is: (1) how do I go about it and (2) is there a better way to lock user acces to the tables/queries/vba...

Wrong date format I can't change. [ 8 Answers ]

I'm using MS Works 8.5. When I click on Format/Number/Date the exact format I want is not shown and the preview is often different from that. i.e. it shows as say 31/8/07 and I want 8/31/07 as I'm in Australia. How can I change it to what I want? Help would be much appreciated. Stuartp77

View more questions Search