function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
shan876shan876 

Formula Help pleaseeeeeeeeeee

Hi I have the following:
AND
(DATE(YEAR(Contract_End_Date__c ) , (MONTH(Contract_End_Date__c), DAY(Contract_End_Date__c)-60 > Contract_End_Date__c , ispickval(Contract_Type__c ,"Renewal")))

I do not know where am I going wrong... It stating I am missing a parenthesis ...
I am trying to say:
1.if the Contract Type = "Renewal"
2. AND the contract is 60 days before the contract End Date
3. send out an email...

I am totally a newbie on this.. Am I doing this correctly????
rumblerrumbler
The parenthesis issue is that you have an extra '(' before MONTH, are missing a ')' before the '>', and have an extra ')' at the end of the formula.

However, I think what you really want is a time-based workflow rule where the rule formula is simply ispickval(Contract_Type__c ,"Renewal") or just a simple criteria where Contract_Type__c equals "Renewal". Then add a time-dependent workflow action that fires 60 days before your custom date Contract_End_Date__c and sends the e-mail as the action.

George
shan876shan876
Awesome the time workflow worked out realll easilyyy thanks