Date Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've tried unsuccessfully to set up a report title that would say

Compilation Report for the month of ______
every function I put in give me either long or short date format
I know this has to be an easy fix.

Thanks
 
Is this a text box? What is the control source? Where does the month value
come from?
A WAG is you can use Format([SomeDateValue],"mmmm").
 
=?Utf-8?B?UmVuw6k=?= said:
I've tried unsuccessfully to set up a report title that would say

Compilation Report for the month of ______
every function I put in give me either long or short date format
I know this has to be an easy fix.

Thanks
Click to expand...

You can use the Format function. Set the controlsource of the text box to:

="Compilation Report for the month of " & Format(Date,"mmmm")
 
Back
Top