Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 809
  • Last Modified:

How print month name using date on a report

I am trying to print the name of the month using a date on a report.  So if for example the date on the report is 6/20/2014 then I want a field to show "June".

How?
0
SteveL13
Asked:
SteveL13
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
=format(#6/20/2014#,"mmmm")

=format(DateField,"mmmm")
0
 
Dale FyeCommented:
For a lot of my reports, I like to put the month in the reports title, which is a label.

To do so, I use the Report_Open event, something like:

Private Sub Report_Open

    me.lbl_Title.Caption = "Some Report Name (" & Format(date(), "mmmm") & ")"

    'or for month year
    'me.lbl_Title.Caption = "Some Report Name (" & Format(date(), "mmm yy") & ")"

End Sub
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now