You need to sign in to do that
Don't have an account?
Linda Hope 27
Calculate retirement date by subtracting retirement age from birthdate
How can i calculate retirement date (Retirement_Date__c) by subtracting birthdate (birthdate) from retirement age (Retirement_Age__c). I would like to breakout the birth date by years and months to make the retirement date more accurate.
I tried to write the formula and was getting an error
I tried to write the formula and was getting an error
Make sure that the 2 fields are same datatype - date.
Then simply use the subtract methor Date1-Date2.
More Data formulas to play around : https://help.salesforce.com/articleView?id=formula_examples_dates.htm&type=5
Regards,
Krishna Avva
Month(Date) and Year(Date) will give you the respective values.
Simple code Follow this step you get the difference between two dates:
I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks and Regards,
Ajay Dubedi
www.ajaydubedi.com