My Change manager would like to have email reminders to go out to all Change Owners where the Change Status is Requested or Scheduled and ScheduledEndDate is before the current day. It's really easy to find these changes, but I'm having trouble figuring out the best place to setup the automation.
I thought a workflow at first, but I couldn't figure out how to test the current date against the ScheduledEndDate in a loop.
I didn't seem to be able to make a Business Rule Trigger test work with the two Statuses. Maybe I should do two triggers? One for each status with an expression to test the ScheduledEndDate.
If anyone has done this before or could point me in a direction, that would be helpful.
1-18-2018 4-03-36 PM.png 21.0 K