Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2005
    Posts
    43

    Unanswered: convert date from one format to another

    greetings, all:

    I am trying to produce a report that has a field that is a short date (mm/dd/yyyy), however, I want to produce a report that shows the date as yyyy-mm.

    any guidance?
    Mos

  2. #2
    Join Date
    Jun 2005
    Posts
    43
    nevermind - just figured it out!

    for those interested...
    in query mode, select the field, and with your properties window open,
    - select Format and type (in my case) yyyy"-"mm (any delimiter needs to be in quotations)
    Mos

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Place an unbound textbox on the report and as it's Control Source use

    =Format(YourDateFieldName, "yyyy-mm")

    Linq
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •