Format and Display month in Header 1

[ThePixelMines]

I've created a monthly summary report to summarize my invoices. It's based on a date range. I want a header that displays the month and year based on the [End Date] of the requested date range. For the sake of this example imagine I'm using the date range of 4/1/2007 to 4/30/2007. To do so I wrote:

=DatePart("m",[End Date]) & " " & DatePart("yyyy",[EndDate]) & " Summary"

This returns 4 2007 Summary which is pretty close, but I don't want "4" I want "April." So, I added Format:

=Format(DatePart("m",[End Date]),"mmmm") & " " & DatePart("yyyy",[EndDate]) & " Summary"

This is the kicker. When I add the 'Format' I get back January 2007 Summary! What? Why January? No matter what the date range I still get January.

Please...Gurus of Tek-Tips...impart your wisdom upon me.

Thanks in advance.

Check it, Fool!

http://www.thepixelmine.com

 

[PHV]

Why not simply this ?
=Format([End Date], "mmmm yyyy") & " Summary"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ThePixelMines]

Well, thank you kindly, PHV. That indeed did the trick. I had derived the aforementioned code from the help files which (as I'm sure we're all well aware) are not very clear. Dare I say, convoluted.

Now, just out of curiosity, does anyone know why my previous attempts were yielding a "January" response?

Thanks!

Check it, Fool!

http://www.thepixelmine.com

 

[PHV]

Just because DatePart("m",#2007-04-30#) is 1900-01-03

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886