Date question

[MikeCitizens]

We run several reports with date ranges. I need to express what date range the report is for in the report header. I cannot seem to find a special field that displays this easily. Do I need to write a formula for this? I found in the special fields a field named Record selection formula which show the date range, but it includes all my other selection ranges.

Better example of what I need.

formula for date range is
{transactiondate} in date (2002,08,01) to date (2002,08,30)

I need a field in the header of the report that basically says Period___________ to _____________ with 8-1-2002 and 8-30-02 filling into the blanks.

Anyone know how to do this? Seems like it should be an easy answer and I know I'm going to kick myself.

please help

Mike

 

[Naith]

Minimum({@DateRangeFormulaOrParameter}) for the first gap.
Maximum({@DateRangeFormulaOrParameter}) for the second gap.

Kick away.

Naith

 

[MikeCitizens]

Thank you it works perfect.

thanks for the really quick response

Mike