Need to calculate Date value depending on Contact Status. Please support me in this. I have created one - but nothing is calculated.
DATEVALUE(IF( ISPICKVAL(ECO_Status__c, "Enquiry approved")," DATEVALUE(Last_ECO_Check_Complete_Date__c) + 84",IF( ISPICKVAL(ECO_Status__c, "License Approved")," DATEVALUE(Last_ECO_Check_Complete_Date__c) + 182", null)))
4 answers
IF(
ISPICKVAL(ECO_Status__c, "Enquiry approved"),
Last_ECO_Check_Complete_Date__c + 84,
IF(
ISPICKVAL(ECO_Status__c, "License Approved"),
Last_ECO_Check_Complete_Date__c + 182,
null
)
)
