@Aleksi I see you have previously given an answer to a similar question:
Your answer was in the context of checking to see if it exists so to speak:
I am looking to determine what events overlap with a date and list them as enum options.
an example being
task 1 from 1/1/2020 to 3/1/2020
task 2 from 3/1/2020 to 5/1/2020
task 3 from 1/1/2020 to 3/1/2020
todays date is the 2/1/2020
I would now like an enum column to detect the overlaping events and list task 1 and task 3 as options.
I am also unsure of where to place the expression to create this column.