I am hoping someone can help.
I have a contract Expiry date and a contract termination period Picklist (30,60,90,120,150,180 days etc) and i would like to create a calculation so that if the Contract Expiry date is 16/05/2019 and the termination period was 30 days to provide me with the renewal date ?
Is this possible ? the criteria for all of the values would need to be taken into consideration ?
답변 10개
Sure, you can use the new ADDMONTHS Function, like this
ADDMONTHS(Contract_Expiry_Date__c, - VALUE(TEXT(Contract_Termination_Period__c)))
