Formula to select rows based on paritions

[champ24]

Hello,

I am trying to select data if a month exists in a given date range. The formula I am using in the filter tile is:

([YEAR]=datetimeyear([START_DATE]) or [YEAR]=DateTimeYear([END_DATE])) and ([MONTH] >=DateTimeMonth([START_DATE]) and [MONTH]<=DateTimeMonth(END_DATE]))

It works if a person has only one single date range. But if a person has multiple date ranges then its not excluding data correctly. Below is the snapshot of input and expected output. Months 5,6,7 doesnt exist in the start_date and end_date ranges and those rows shd be the output.

Is this possible?

[champ24]

Thank you all. a222 is still showing all rows. As I mentioned earlier it should show only these

a222	2020	1	Barista John
a222	2020	2	Barista John
a222	2020	3	Barista John
a222	2020	4	Barista John
a222	2020	5	Barista John
a222	2020	6	Barista John

[champ24 · Accepted solution]

I created the workflow and seems to be working correctly. The only way it seems to be possible is to exclude the specific rows and handle separately through a couple of filters and then union.

[atcodedog05]

Hi @champ24  is there any specific logic for only those rows to be outputted.

[champ24]

The logic I am using is to exclude End_date with nulls and then adding a filter on it.