You need to sign in to do that
Don't have an account?
Anirudh Sharma 5
formula field to calculate approximate Age?
I have a pick list called "Year" which referes to person Year of birth and I want to calculate the approximate age in years and display in a text field so how do write a formula field to get the Approx Age of the person.
Thanks
Thanks
TEXT(YEAR(TODAY() ) - VALUE(TEXT( Year__c )))
All Answers
TEXT(YEAR(TODAY() ) - TEXT( Year__c ))
TEXT(YEAR(TODAY() ) - VALUE(TEXT( Year__c )))