Portal filter based on two sets of criteria
So I have a portal that lists a large set of contract records with expiry dates.
There is a filter to show contracts that have not passed the expire date, I'm using this formula;
Contracts 2::Contract end date>Get(CurrentDate)
I also have a check box field for contracts that have been renewed. When this check box is checked (with a Yes value from the Value List) I also want to have the contract removed from that portal.
Can anyone help me with what my formula should look like?