How to display a date range parameter when printing

[ramc2000]

Does anyone know a better way to solve the following issue??

I want to able to display the date range value my report is using when printing a copy of the report. I've tried the following:

"From: " & Minimum ({?Dates}) & " To: " & Maximum({?Dates})

But I don't think this is the best way to go. What's gonna happen here is that if your maximum date falls behind the "ToDate" parameter entered, when you print out your report it will be confusing for someone not familiar with the dates entered as parameters.
Example:
Dates entered as parameters:

From 10/01/02 to 10/31/02
Actual maximum date in data: 10/20/02
actual minimum date in data: 10/01/02
Thus, we'll get:

From: 10/01/02 To: 10/20/02

Is there a way to display the exact date range used in this case?? Thanks in advance.

 

[jlsmithhartfiel]

Well, if they are entered parameters, you should be able to just put those in place of the max function. I create a label and enter "Date Range: ", then drag & drop the parameters in, putting " to " in between so it looks like this in the label:
Date Range: @from_date to @thru_date
Hope this helps,
Jessica

 

[mbarron]

Use this one:
"From" & minimum ({date.field})&" to "&maximum({date.field})

Where{date.field} is the field that you are comparing to the parameter.

Mike

 

[ramc2000]

Hi, I just realized "From: " & Minimum ({?Dates}) & " To: " & Maximum({?Dates}) should work!!
I was actually using the date field in my formula instead of the parameter itself.
Well, at least I won't be making the same mistake again!! Thank you.