Show month as a text string 1

[madsstiig]

Hi.

I'm having a problem getting a report to show for which month the data in the report are in the header (yes, english is not my best...).
E.g. "the data in this report are from [March, 2010]".
The database uses 'DD-MM-YYYY' as dateformat.

Best regards, Mads - Copenhagen, Denmark.

 

[NickieP]

Put a copy of the date field e.g. orderdate in the header area.
customise the format of this copied field to be month and year but no day so that '14/03/10' becomes 'March 2010'
then drag this field into the text box that says
"the data in this report are from [March, 2010]"over [March, 2010]

 

[madsstiig]

Worked like a charm - thank you so much