Date Parameter Question

[fmrock]

I have a report that contains several different date fields. I would like to get the user the ability to choose which date field the date parameter selects from. What would be the best way to do this?

Thanks,

 

[Turkbear]

Hi,
Best way is often hard to determine, but one way would be to create an additional parameter with the field names as the displayed text and a number as the data vaue, then use a selection formula something like:

If {?fieldname} = 1 then
 {DateField1} = {?DateParameter}
else
If {?fieldname} = 2 then
 {DateField2} = {?DateParameter}
...
etc.

To Paraphrase:"The Help you get is proportional to the Help you give.."