Using filter contains for multiple values with dates

[KCAgentProvocateur]

Can anyone help me on the filter below?

I would like to do the below:

[opted out] != "F" AND Contains([Opted Out Date], "2013")

then add years on later in my flow:

[opted out] != "F" AND Contains([Opted Out Date], "2013") OR Contains([Opted Out Date], "2014")

In my first statement i can still see data coming into my false filter result with opted out = T and opted out date = 10/21/2013 01:19PM

Ive attached screenshots.

Thanks,

Kerry

[MichalM]

In which case I've probably missed something. Let me clarify.

Do you want to see all records that opted out (T in the Opted Out column) in years 2013 or 2014 (from Opted Out Date column), correct?

[KCAgentProvocateur]

no i want to see the below:

customers who are opted out = F or customers who are opted out = T and have opted out date containing 2013

[MichalM]

In which case you want to connect the second filter to the F anchor of the first and Union the two outputs afterwards.

[MichalM · Accepted solution]

Here's how it will look

[KCAgentProvocateur]

great thanks!!

[MichalM]

Assuming this worked, could you please mark it as an accepted solution when you get a minute? Thanks!