Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Harley ManHarley Man 

Calculating age from DOB field

Can anyone help me calculate a contact's age by using the Date of Birth field?
 
Thanks in advance,
 
David
EricBEricB
Here's a simple formula that is reasonably accurate:

FLOOR((TODAY()-Birthdate)/365.25)

For simplicity, it cheats a bit on handling leap years.

By the way, this example and many others can be found in this Sample Formulas document:
https://na1.salesforce.com/help/doc/en/salesforce_useful_formula_fields.pdf

Regards,
Eric