Sign Up ›

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

How can I create a formula to calculate a date field and a number field and display the date field accordingly.

I have two fields,
1. Start Date  (Date field) eg. 12/10/2020
2. Tenure field (Number field) eg. 2years
I want to create a new field which will calculate the end date based on the two fields above.
i. e End Date field: 12/10/2022

Currently I am using this formula but the output is incorrect. 
"Contract_Start_Date__c + (  Contract_Tenure__c  * 12)"
 

Best Answer chosen by Nyshaa
NyshaaNyshaa

I was able to solve it,

ADDMONTHS(Contract_Start_Date__c,Contract_Tenure__c *12 )

This will return end date value based on the two field.

All Answers

NyshaaNyshaa

I was able to solve it,

ADDMONTHS(Contract_Start_Date__c,Contract_Tenure__c *12 )

This will return end date value based on the two field.

This was selected as the best answer
Sean Sand 3Sean Sand 3
Thanks for sharing your reply here keep share your queries here
so anyone from the community who has faced the same issue can also find 
the solution from comments below, keep sharing TellPopeyes (https://www.tellpopeyes.biz/)