Date Format Code

Discussion in 'Microsoft Access Reports' started by rml, Jun 7, 2009.

  1. rml

    rml Guest

    How can I make the following code convert the date portion to dd/mm/yy
    instead of the standard mm/dd/yy?

    = Trim([CreateDate] & " / " & [Tech])

    Thanks.
     
    rml, Jun 7, 2009
    #1
    1. Advertisements

  2. rml wrote:

    >How can I make the following code convert the date portion to dd/mm/yy
    >instead of the standard mm/dd/yy?
    >
    >= Trim([CreateDate] & " / " & [Tech])



    This is different from your other formatting question.
    Here, you need to use the Format function:

    =Trim(Format(CreateDate, "ss/mm/yy") & " / " & [Tech])

    --
    Marsh
    MVP [MS Access]
     
    Marshall Barton, Jun 7, 2009
    #2
    1. Advertisements

  3. "Marshall Barton" <> wrote in message
    news:p...
    > rml wrote:
    >
    >>How can I make the following code convert the date portion to dd/mm/yy
    >>instead of the standard mm/dd/yy?
    >>
    >>= Trim([CreateDate] & " / " & [Tech])

    >
    >
    > This is different from your other formatting question.
    > Here, you need to use the Format function:
    >
    > =Trim(Format(CreateDate, "ss/mm/yy") & " / " & [Tech])


    Slight typo. It should be

    =Trim(Format(CreateDate, "dd/mm/yy") & " / " & [Tech])


    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)
     
    Douglas J. Steele, Jun 7, 2009
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest
    Replies:
    2
    Views:
    606
    Fran├žois Uldry
    Feb 13, 2004
  2. Guest

    Convert SNP format to PDF Format

    Guest, Nov 23, 2004, in forum: Microsoft Access Reports
    Replies:
    5
    Views:
    3,017
  3. Guest
    Replies:
    3
    Views:
    397
    Duane Hookom
    Apr 28, 2005
  4. t m via AccessMonster.com

    need a date on a report to match the date when ask for date of report

    t m via AccessMonster.com, Sep 8, 2005, in forum: Microsoft Access Reports
    Replies:
    4
    Views:
    241
    Guest
    Sep 8, 2005
  5. Guest

    snapshot format selected, file is created as .xls format

    Guest, Oct 11, 2006, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    188
Loading...

Share This Page