custom filter

[lezawang]

Hi
I have a column which has random dates. I inserted a filter. I click on Date Filter and I see all options, after, before, between etc. Then I see custom Filter and I see AND and OR. I just want to know an example that I need to use these 2 options. I thought everything is already covered under Date Filter. Thank you.

 

[Dryver14]

What a strange question...some people have a lot of time LOL

what if you wanted to look at the date just for 03/02/18 and 15/03/18

I most admit, not sure about OR but I am sure you will think of something

 

[lezawang]

Thanks for the help anyway. But that is OR not AND
I tried 1/1/2016 OR 1/1/2017 , I got something
but when I tried 1/1/2016 AND 1/1/2017 I got nothing.

Thanks

 

[philwojo]

Doesn't mean Dryver14 was wrong, it just means your data set didn't have both of your dates in it. It did have one, and that is why OR worked, but for AND to work both must be in the list.