So, you no longer want user input for the date, you want the formula field to do the calculation instead?

If that's the case, then remove the parameter field and in its place, drag your new formula field to the canvas.

Edited by hello - 21 Feb 2014 at 8:11am

I think I understand you...

But, you can't limit or suppress a whole record in a formula field, only in the Select Record formula area.

So, under Report - Select Expert - Record...create your formula there. You will see the parameter field represented as a ?{} after you click on the "new" tab and choose your {table.date} field and probably the "is less than" from the pull down options.



Edited by hello - 21 Feb 2014 at 9:59am

Do you mean you are trying to pass a parameter down to your sub report?

Going back to the original post, the formula you created cannot be used as a parameter as the outcome, prior to reading any records is not deterministic.

It sounds like she needs both records, but only 5 days in the future, so it would seem that she would want a date parameter, which was there before she revised the report and logic in the record selection formula (since as hello said that is the place to limit records, and you only want the open records to 5 days in the future).

one would think something like:
if {already fulfilled} then
true
else
if {should be filled in the next 5 days logic} then
    true
else
    false

usually to get a different date than the parameter you would use a function ADDDATE, which would like: ADDDATE("d",5, {?DateParameter})...but you probably already knew that.

Hopefully this is clearer than mud.

?