I am having trouble with something I thought would be very simple.
I have a list of things that each have a date range in a custom state. I want to filter a list of dates based off the above list of things (their ranges). Basically, I want to do is Advanced filter:
Date/time < Range> This Date doesn’t contain any of the ranges in the custom state
Custom state’s list of things each item’s range is not in date/time < Range > This date
I cannot get an expression that is around this/gets this outcome. Any help is appreciated!