In the Change module, we want to send out a notification when the Change is 7 days past the Scheduled End Date and it has not been Completed, Closed or Cancelled. The Saved Search is run as part of a scheduled workflow that runs everyday at 6:30 AM in the morning. I'm trying to use the AddDays function to narrow down the Schedule End Date using this Saved Search
But I'm getting Changes that are falling outside the range and I'm not sure why or how to resolve.
I'm looking for any suggestions from anyone who might have successfully done this.