Results 1 to 4 of 4
  1. #1
    louise is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    112

    Insert custom date into a report

    Hello,
    I would like to insert, into the title of a report, the current date in this format: January 5, 2019
    Could you tell me the method for accomplishing this?

    Thanks!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Try a textbox with this control source:

    =Date()

    and play with the format setting. I think long date may work.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,412
    format property should be something like

    mmm d, yyyy

  4. #4
    louise is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    112
    Thanks for the help!
    Here, quite specifically, is what worked for me:
    In the design view of the report, click on the section where you want the date, click on “Date and Time” in the Header/Footer section, select any of the date options, and uncheck the time option. Position and format the text box as desired.
    Then, with the date field selected, go to its properties and under the FORMAT section, type this:
    mmmm d”, “yyyy
    This yields, for example, August 4, 2018

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 12-07-2018, 12:32 PM
  2. Replies: 3
    Last Post: 12-31-2014, 10:11 AM
  3. Custom Report by date then time
    By LostOne in forum Reports
    Replies: 2
    Last Post: 05-22-2014, 08:38 AM
  4. insert a specific date in report footer
    By Rasha in forum Access
    Replies: 3
    Last Post: 04-23-2014, 12:12 PM
  5. Custom Message Box for verifing RunSQL Insert
    By robsworld78 in forum Programming
    Replies: 8
    Last Post: 05-01-2013, 09:33 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums