+ Start a Discussion
Karla Pliego 3Karla 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? 
Ankur Saini 9Ankur Saini 9
Hi Karla,

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