How do you display Date Values used to select records

[Former Member]

I set up a date range parameter so that I can look at data for a week or month, etc.  I know there is a way to add a parameter value to the page heading by inserting it into the text box but it does not seem to be working for the date range.  Is there something special you have to do when dates are involved?

My report is a summary report so the date of the various transactions are not listed on the report, those details are hidden from view.  I don't know if this would affect things or not.

[abhilash_kumar · Accepted solution]

Hi Rebecca,

Create a formula with this code and place it on the header:

Minimum({?Date_Range}) & " To " & Maximum({?Date_Range})

-Abhilash

[Former Member]

This worked perfectly, thank you!

[DellSC]

You'll need to create two formulas for this:

{@StartDate}

Minimum({?MyDateParameter})

{@EndDate}

Maximum({?MyDateParameter})

Then put a text box on your report and do the following:

1.  Drag the start date formula into it

2.  Position your cursor in the text box after the start date formula.

3.  Enter "-" or " to " or whatever you want to separate your dates.

4.  Drag the end date formula into the text box, positioning it after the text that you just typed.

-Dell

Message was edited by: Dell Stinnett-Christy