You need to sign in to do that
Don't have an account?
SalesforceCrm AccountCRM
System should automatically calculate 100 days before the contract end date
Hello ,
I have a requirement ,where the system should automatically calculate 100 days before the contract end date and send an alert to the customer.How can we formulate the formulae ,
I have a requirement ,where the system should automatically calculate 100 days before the contract end date and send an alert to the customer.How can we formulate the formulae ,
1)Date dt = Today()+100 and then assign it to contract end date =:dt in a query 2) Date ed = Date.today().addDays(100); 3)contract end date >=Today+100days 4)Date=(today+100 - contractend date)or how can we calculate..Im in dilemma which one should work to calculate.Any thoughts or ideas or example very much appreciated.
You can achieve this functionality by using Workflows with Time trigger or Process Builder.
Please check the below screenshots.
Step1: Create a Workflow rule on Contract Object.
Step2:
Step3:
Step 4:
Hope this helps you!
Best Regards,
Jyothsna
All Answers
You can simply create a formula like this :
DaysDiff = (contractenddate - today())
This will give the no of days.
Based upon the above formula field you can set an alert using workflow which will have the condition like this: If DaysDiff is eqaul to 100 then send an alert.
Regards,
Kiran
You can achieve this functionality by using Workflows with Time trigger or Process Builder.
Please check the below screenshots.
Step1: Create a Workflow rule on Contract Object.
Step2:
Step3:
Step 4:
Hope this helps you!
Best Regards,
Jyothsna
You can set the conditons from the workflow rules like this:
Refer the below screenshot