add date to title of report (1 Viewer)

swmorin

Registered User.
Local time
Yesterday, 21:26
Joined
Jan 10, 2012
Messages
66
I want the title of my report to list the date in the title.

I.E. Unavailable Instructors for 06 Mar 12

I tried this:
Code:
="Unavailable Instructors for " & now("dd-mmm-yyyy")

I also need one for this week, next week, this month, and next month,this quarter, next quarter, this year, next year

I know this is a lot but any help would be appreciated
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 19:26
Joined
Aug 30, 2003
Messages
36,118
Try

="Unavailable Instructors for " & Format(Date(), "dd-mmm-yyyy")

Now() would also work, but since you don't need the time I'd just use Date().
 

swmorin

Registered User.
Local time
Yesterday, 21:26
Joined
Jan 10, 2012
Messages
66
Thanks for the quick response How would I do the others?

This week,
Next Week,
This Month,
Next Month,
This Quarter,
Next Quarter,
This Year....
 

Users who are viewing this thread

Top Bottom