I need help with some Data in Set analysis. I want to see all machines which are currently in a contract. Some of them have a termination date (Field "[Kündigungsdatum Vertragsposition]") already but most of them not. The conditions are:
[Kündigungsdatum Vertragsposition] is null OR [Kündigungsdatum Vertragsposition] >= today()
With my following Set Analysis I just get every machine with a termination date greater than today:
To fetch NULL within the set analysis is difficult and couldn't be done on the field itself else it will need an indirect set analysis - therefore the suggestion from sasiparupudi1 to use another field for it. But in the way it's applied the conditions have an AND connection which could be never true - else it needs an OR connection.
I think it should be possible to develop such an approach but I would rather try to reverse the logic with something like:
Maybe even better as that might be to fill these NULL's with real values within the script - in your case maybe with the 31.12.9999. With it those records will be selectable again and your statement of: