I have a layer of assets. I want to be able to filter by the status of the asset and it's due date, OR between a user-selected date range.
So, I want it to automatically show all assets that aren't complete and were due before today, and ALSO all assets with a due date between a user selected date range.
Basically, this sql query:
(IsComplete = "N" AND DueDate < today) OR DueDate is between date1 and date2
I can't seem to make this work. When I create a set with the first (set to match all expressions) and then add the last date expression, it gives everything the AND operator. It seems that everything must be one or the other, i can't mix and match operators. Is there any way to make this work?
