Date Header Issue

[csegal]

Hello,
I have a report where I want to place a date header on each page ie...
First Page: January where this page will list all of the activity for January
Page two: February and so on.
I am currently using =([Date])
This is giving me the actual date of the first record such as if the first record was January 4, 2005 I get 1-4-2005

I want to have the header state: JANUARY, 2005

How do I go about this???

 

[RoyVidar]

In the format property of the control, enter:

[tt]mmmm", "yyyy[/tt]

If you need all capitals, do not use the format property, but try the following as controlsource:

[tt]=strconv(format([Date],"mmmm, yyyy"),1)[/tt]

- and for the next project, don't use Date as name of a field, it'll going to create headaches;-)

Roy-Vidar

 

[lupins46]

Use a group header instead.

Add a group based on your date field and in the GroupOn property choose Month from the drop down list.

Add a textbox to your group header with the control source looking like:
=Format$([MyDatefieldnamehere],"mmmm yyyy")