1 Reply Latest reply on May 15, 2018 8:06 AM by scott.phillips

    filtering to a date range in a saved search

    kcmpk Rookie

      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.