I'm building a process definition intended to email users when a meeting end date has passed and the meeting status is still "scheduled". My process includes a timer that waits 3 days after the first entered end date. After the wait time has passed, I added a gateway to re-evaluate the end date on the meeting to make sure it was not changed to a future date. [e.g. end_date < now() ]
Is there a way to insert mySQL functions into SugarBPM? The evaluation settings only allow me to select an explicit date, but I need this to be dynamic based on the current date.
Thank you for your feedback and any suggestions on how I could accomplish this.
