Input Date Range Parm not displaying 3

[TimothyP]

I am converting a CCYYMMDD string field to a date field with the following formula:

cdate (mid({Table.Datefield},5,2)&"/"&right({Table.Datefield},2)&"/"&left({Table.Datefield},4))

I named the above formula "f_converted_date".

I have a date range input parameter to select a range of dates off my source table.

My selection criteria looks like this ({@f_converted_date} = {?Date_Range}.

My report seems to be selecting the correct dates for the detail records successfully. However, when I try to add the ?Date_Range input parameter to the title of the report, it is blank.

Any suggestions?

Thanks in advance,
Tim

 

[vidru]

You need to handle range parameters differently than discrete params when placing them on a report. Ranges are treated like arrays, so you need to use a formula to get the dates out:

//@DisplayRange
"From: " + ToText(Minimum({?Date_Range}), "MM/dd/yyyy") + " to " + ToText(Maximum({?Date_Range}), "MM/dd/yyyy")

-dave

 

[synapsevampire]

I have a FAQ on this:

faq767-5684

It covers what you speak of plus the various combinations on ranges and discrete values.

-k