You need to sign in to do that
Don't have an account?
shan876
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????
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????
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