I'm not sure if i stated correct, im trying to send reminder when the status is open, pending and past due. I query these 3 items.
Status is Equal to open
Status is Equal to pending
Target Completion is less than or equal to current date
ANy suggestion and help is much appreciated.
Thank you very much
Solved! Go to Solution.
how are you combining the condition? The two status condition should be joined in OR and the date filter should be in AND