Parameter - Date Range 1

[jrcol12357]

I would like to display a date range in my report that the user has selected in the parameter to begin the report. Example: {VW_BROKER_CLOSING_MASTER.DISBURSEMENT_DATE} in {?Disbursement Date} User selects April 1, 2007 - May 31,2007 for the range. Those dates are what I want to show.

If I set my parameter to >= a single date I can show that date, but not when using a Date Range. I have also tried to use Minimum{?Disbursement Date} and Maximum{?Disbursement Date}

Thanks in Advance

 

[lbass]

Create a formula:

totext(minimum({?daterange}),"MMMM d, yyyy") +" - "+
totext(maximum({?daterange}),"MMMM d, yyyy")

-LB

 

[jrcol12357]

Thank you.
After posting I found this information "Only single (discrete) parameters are effectively displayed this way. To display multiple values or ranged values, you must create a formula that extracts the whole set or range of values the user has entered”.... The following formula will display the starting and ending dates of a date-range parameter field. "Disbursement Date Range" + toText(Minimum({?Disbursement Date}), " M/d/yyyy ") + " through " + ToText(Maximum({?Disbursement Date})," M/d/yyyy").

 

[lbass]

There is an FAQ that shows how to display various types of parameters:

faq767-5684

-LB