Filtering data

[BenMurrells]

Hi All

I'm trying to exclude data from a dataset based on just two parameters.  To clarify I need both parameters to be fulfilled in order to exclude from the dataset.  For example if Entry Date and  Code match the parameters below then exclude from data.  I can't do this as a step formula pattern because it will exclude data on one field only and then the next.

Entry Date should be before 1st January 2023

Code should be = 0

Can anyone point me in the right direction for the formula expression?

Any help appreciated.

[DataNath · Accepted solution]

Hey @BenMurrells, if I'm reading this right then you'll be able to just put both conditions in a filter using an AND operator and the records you're excluding will come out of the top (True) anchor, so you'll be interested in the bottom (False) results. Attached a workflow below for reference using this expression:

[Date] < '2023-01-01'
AND
[Rand] = 0

Where Date and Rand are just 2 fields I've made to mimic your Entry Date and Code fields.