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

Workflow

Accepted answers

Here's how it will look

All comments

Hi Kerry,

For dates you will need to do DateTimeFormat([DateField], %Y) = 2013

Hi @KCAgentProvocateur ,

What's the data type of your date field? Is it a date or a string?

KCAgentProvocateur

it is a string - do i need to use it in date format if i am just querying that it contains the year?

@KCAgentProvocateur No you shouldn't have to convert it to a date and the Contains() function should work. Is it possible for you to attach an example of your flow?

KCAgentProvocateur

they are all string - really not sure why its not working.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703