flowfield - filter absed on date issue

Washout

Hi,

Im trying to create a flowfield which looks up a differant table value.

The filter I want to use is Today-1.

Is this possible using flowfield?

awarn

I think what you want to to is filter a flowfield based on a dynamic value, so you need to create a new field (or use one that is there), that is a flowfilter, and then have this flowfilter be included in the calculation of the flowfield.

Look at the Item table, Net Change field, CalcFormula, Table Filter. You can see that based on the dynamic selection of the field 'Date Filter', that the formula looks at different posting dates.

In your case, you can se the field in code, something like:

DateToFilterBy := CALCDATE('-1D',TODAY);
SETFILTER("Date Filter",FORMAT(DateToFilterBy);

I hope this is what you mean!

-awarn