I’m looking to trigger an event action email in IFS Cloud when the system date equals the date entered in the date field. I have tried entering TRUNC(SYSDATE), TRUNC(CURRENT_DATE), and #TODAY#.
I have been using the NEW:EXP_DATE field. I’m trying OLD:EXP_DATE to see if this triggers.
Does anybody know how to trigger an email when dates match?
Hi
In your custom event under the custom attributes section you create a new data type variable such as EXP_date_ and in the server method you can type
trunc(:NEW.EXP_DATE)
In the event action conditions you can use the above EXP_DATE_ variable and match with trunc(sysdate)
EXP_DATE_ = trunc(sysdate)
this way both date formats will match . You can fill in the email and other details as needed
Good morning,
The proposed solution did not work, but I solved this a different way. YOu need to create a custom attribute that will change based on sysdate. This is the trigger you use in the action.
I created DATE_MATCH and set the server method as: CASE WHEN &NEW:CF$_EST_INVOICE_DATE = TRUNC(SYSDATE) THEN 1 ELSE 0 END
Then I used DATE_MATCH = 1 to trigger my event action.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.