In order for a filter to work you need to create a calculation with a bolean result.
Meaning that the calculation is either true or false.
A value other then "0" is considered True.
"0" or no value at all is considered False.
So what you need to come up with is an expression that is either true or false (either 1 or 0)
If ( PortalTable::Date > Get ( CurrentDate ) - 60 ; "1" ; "" )
This expression means that if the date in the portal is larger than 60 days ago it will be "True" otherwise it will be "False".
An expression like that will work as a filter.
I hope this makes sense.
Thanks, yes. So all those instances for which the result is TRUE will display?
Now remember that this will be evaluated per portal record. So that's why you need to use the date field from the Table Occurrence that the portal is based on.
You can see this when you double click the portal it says on the top "Show related records from..."
That's the table occurence you need to point to.
So if that says: "AdSales" You need to use the Date field from AdSales in your filter calculation.
But I'm sure you got that one.
Yes, and it works--thanks.