Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Changing date format

Discussion in 'Information Technology' started by Rhino, Jul 28, 2006.

  1. Rhino

    Rhino
    Expand Collapse
    Guest

    How do I change the format that Access 2002 uses to display dates?

    I'm inputting dates in ISO format (e.g. today's date is 2006-06-25 in ISO
    format) and Access is understanding them correctly but it is displaying them
    as DD/MM/YYYY. I've looked in Options and in the Help system but can't find
    how to change the presentation format that Access uses.

    --
    Rhino
     
  2. Loading...

    Similar Threads Forum Date
    S Asia Thinking about the big move: The Sikh way of life changing in Khyber-Pakhtunkhwa Breaking News Mar 22, 2014
    Opinion Haanji's Quick Takes on a Changing World (September 23, 2013) Breaking News Sep 22, 2013
    Changing my last name to Kaur... Questions and Answers May 15, 2013
    Life-changing Inspirational Stories Mar 31, 2013
    USA Sikhism and the Changing Electoral Demographic Breaking News Mar 8, 2013

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Access displays dates according the the format defined in the Regional
    Settings in the Windows Control Panel.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Rhino" <no.offline.contact.please@nospam.com> wrote in message
    news:OH2a4OGmGHA.3752@TK2MSFTNGP02.phx.gbl...
    > How do I change the format that Access 2002 uses to display dates?
    >
    > I'm inputting dates in ISO format (e.g. today's date is 2006-06-25 in ISO
    > format) and Access is understanding them correctly but it is displaying
    > them as DD/MM/YYYY. I've looked in Options and in the Help system but
    > can't find how to change the presentation format that Access uses.
     
  4. Rhino

    Rhino
    Expand Collapse
    Guest

    "Rhino" <no.offline.contact.please@nospam.com> wrote in message
    news:OH2a4OGmGHA.3752@TK2MSFTNGP02.phx.gbl...
    > How do I change the format that Access 2002 uses to display dates?
    >
    > I'm inputting dates in ISO format (e.g. today's date is 2006-06-25 in ISO
    > format) and Access is understanding them correctly but it is displaying
    > them as DD/MM/YYYY. I've looked in Options and in the Help system but
    > can't find how to change the presentation format that Access uses.
    >


    I finally found out how to adjust the date formats after I did a fresh look
    in the Help.

    I had assumed that the date format was set within Access or maybe Office
    somehow.

    I finally discovered that the date formats used in Office are set for
    Windows within the Control Panel Regional Settings. I set the format I
    wanted there and now my dates are being displayed in the format I want.

    Sorry if I wasted anyone's time with this question.

    --
    Rhino
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Sun, 25 Jun 2006 10:41:08 -0400, "Rhino"
    <no.offline.contact.please@nospam.com> wrote:

    >I had assumed that the date format was set within Access or maybe Office
    >somehow.
    >
    >I finally discovered that the date formats used in Office are set for
    >Windows within the Control Panel Regional Settings. I set the format I
    >wanted there and now my dates are being displayed in the format I want.


    It CAN be set in Access (as well as in Regional Settings). The
    Regional setting defines how Access interprets the "Short Date" format
    (among others); but you can also use explicit formats in Access, such
    as mm/dd/yyyy or yyyy-mm-dd. These will take effect regardless of the
    regional setting.

    John W. Vinson[MVP]
     

Share This Page