I have a query in my workflow that looks at an Out Of Office list and queries 3 columns, to get the Delegate To person to assign the task to:
Delegate From = Approver
Start Date <= Today
End Date >= Today
However, I was wondering if it was possible to allow the End Date to also be NULL? Like if someone (ex: a high level person) wanted to delegate all tasks forever, how do I build the query that says:
Delegate From = Approver Assigned
Start Date <= Today
(End Date >= Today OR End Date IS NULL)
I tried adding the NULL to the query but I get the wrong result. I set up 2 Out Of Office items, one with a date in range and a date starting next week with no end date. I get the result for next week. I also removed the end date from a few others and it picked the first result with a NULL End Date.