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
whatever513whatever513 

Automatically Update a Contract End Date

When creating new Accounts on the Accounts Tab I have the field for Service Start Date where the Date is picked from the popup calendar and a field called Contract Length (Months) with 4 Picklist options (36, 48, 60, 72). Is there a formula that can be created that would automatically update and create a Contract End date using these 2 fields?

Best Answer chosen by Admin (Salesforce Developers) 
Pradeep_NavatarPradeep_Navatar

Use following formula :

 

Start_Date__c + (365 * VALUE(Text(Length__c)) / 12)

 

where Start_Date__c stands for Service Start Date and Length__c stands for Contract Length which is a picklist.

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.