Need formula: Print the month that is the date range 2

[loveyoursite]

CRV 10. I would appreciate someone's help with a formula. I have a report with a date range. I would like the title of the report to contain the month and year text that relates to that date range.

For example, if the date range is 4-1-05 to 4-30-05, I would like in the title: APRIL 2005 Monthly Report.

Another example, if the date range is 11-09-2004 to 11-30-2004, I would like in the title: NOVEMBER 2004 Monthly Report.

Thanks a lot!

 

[kskid]

Assuming that the data range is a parameter, {?daterange}, try this

ToText(min({?daterange},"MMMM yyyy")) + " Monthly Report"

-LW

 

[loveyoursite]

Sorry.... the report has 2 parameters prompting the user to enter: {?startdate} and {?stopdate}. When I use one of them in the formula it says "This field cannot be summarized".

 

[dgillz]

ToText({?Startdate},"MMMM yyyy")

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[loveyoursite]

That worked! Thanks a lot!