Apex Code Development You need to sign in to do that
Don't have an account?
Karla Pliego 3 Formula or workflow for date calculation
We have an email alert that needs to go out X days after a certain date. We currenty have a date field for that certain date and a box where we put how many days after that date we need that email to go out. However, I need this to be automated. I need a formula, workflow rule or process that allows me to calculate what date should the email trigger. and then trigger the email For example, if the days are 5 then the new date based on today's date would be April 30th. On April 30th the email should trigger. So I either need a fomula that adds the 5 days to my date and gets me a new date from where the email alert triggers or something else that achieves the same. How do I create a formula that does this?
Create a new formula field having formula:
CreatedDate (or any other date field) + Num_of_Days__c
Set time trigger as below:
0 days after new date
Thanks
Ankur Saini
http://mirketa.com