Filter specific dates only

[Belletmns]

Hi All,

I need to filter dates with the coverage September 1 to September 15, 2020 only.

Here is my raw data:

Hers is my desired output:

Thank you!!

[DavidP]

Hi @Belletmns 

Here you go

[Belletmns]

Hi David,

Base from the workflow you sent, I added another date 2020-09-15. Which should be included from my final input, but it appears on false.

[BrianR]

Hi @Belletmns, your newly added Start Date is 2020-09-15, so in the case of your filter:

[Start Date] <= "2020-09-01" AND [End Date]>= "2020-09-15"

Both conditions must be met by virtue of the AND statement, and 2020-09-15 is NOT less or equal to 2020-09-01, so that's why that value appears in the False anchor. If you change that AND to an OR, then the statement would be True.

[DavidP · Accepted solution]

Hi @Belletmns,

I understood your requirement as needing full coverage of the 1-15 Sept period. If you want date ranges where any overlap of the 1-15 period is true, the formula should be:

[Start Date] <= "2020-09-15" AND [End Date]>= "2020-09-01"

[Belletmns]

It already works! thank you so much.