How to make alteryx select a specific date window criteria?

[Rahila_H]

Column A contains the date and columns B & C contain the start and end date respectively of a date window.

Scenario 1- two dates '8/10/2023' and '8/11/2023' in column A are falling within the same window i.e., 7/29/2023 to 8/28/2023 but this window should be selected for '8/10/2023'.

Scenario 2- Same date, i.e., '9/29/2023' in column A is falling in two different date windows but only the first date window should be selected for '9/29/2023' and this date window should not be repeated for any other date, i.e., '10/11/2023' in column A.

For 10/11/2023, the date window '9/28/2023' to '10/28/2023' should be selected.

[cjaneczko]

Didnt you mark this as solved in this post?

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-make-alteryx-select-a-s...