Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Access: Date Format using slashes but america dates come up (https://www.askmehelpdesk.com/showthread.php?t=186722)

  • Feb 21, 2008, 04:12 PM
    missmarple
    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
  • Feb 21, 2008, 05:03 PM
    this8384
    ... what?

    What are you trying to customize?
  • Feb 22, 2008, 10:44 AM
    missmarple
    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?
  • Feb 22, 2008, 10:55 AM
    this8384
    You're not telling me what it is you're trying to customize.
  • Feb 22, 2008, 11:56 AM
    missmarple
    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
  • Feb 29, 2008, 07:29 AM
    ScottGem
    Date formats are set by your Regional Settings in Windows.
  • Feb 29, 2008, 01:23 PM
    missmarple
    Thanks, ScottGem. Got it.

    • All times are GMT -7. The time now is 05:29 PM.