Welcome to SPN

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

Sign Up Now!

How do I change the FORMAT of a date in Access 2003?

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

  1. RheaS

    RheaS
    Expand Collapse
    Guest

    I need to change the actual format of a date in Access 2003 from mm/dd/yy to
    yyy/mm/dd, not just the appearance of the date.

    Got any suggetsions?
     
  2. Loading...


  3. fredg

    fredg
    Expand Collapse
    Guest

    On Mon, 19 Jun 2006 14:32:02 -0700, RheaS wrote:

    > I need to change the actual format of a date in Access 2003 from mm/dd/yy to
    > yyy/mm/dd, not just the appearance of the date.
    >
    > Got any suggetsions?


    I don't quite understand your question since both mm/dd/yy and
    yyy/mm/dd are date formats (which is just the appearance of the date,
    not how it is stored).

    Today is actually stored, in Access, as 38887.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Seeing as how format is appearance I assume you want the date to be text.

    Format([YourDateField],"yyyy") & "/" & Format([YourDateField],"mm") & "/" &
    Format([YourDateField],"dd")

    And I am also assuming you meant "yyyy" instead of "yyy". If you realy ment
    "yyy" then it would be like ---
    Right(Format([YourDateField],"yyyy"),3) & "/" & Format([YourDateField],"mm")
    & "/" & Format([YourDateField],"dd")

    "RheaS" wrote:

    > I need to change the actual format of a date in Access 2003 from mm/dd/yy to
    > yyy/mm/dd, not just the appearance of the date.
    >
    > Got any suggetsions?
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    RheaS wrote:
    > I need to change the actual format of a date in Access 2003 from
    > mm/dd/yy to yyy/mm/dd, not just the appearance of the date.
    >
    > Got any suggetsions?


    Format is a display function, not a storage function. Access stores
    dates as a simple number with no formatting.

    --
    Joseph Meehan

    Dia duit
     

Share This Page