Hi All,
I need to create a basic workflow which should function the below way. Can anyone of you suggest me the logic ?
1. On Account entity I have a date field called 'Expiration Date'
2. An notification email should be sent to user on updating any field on the form.
3. The condition that should be checked for sending email will be .. expiration date should be exactly 30 days ahead of the time when user is updating the fields on the form.
*This post is locked for comments
Hi Alex,
Is there any way to use system built in functions directly instead of going with a new field again ?
Hi SV,
for #3, you might create "whole number" calculated field and use DATEDIFF function to get the difference between NOW() and Expiration Date
Then, on the update of the record, you can use that calculated field in the condition.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156