function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ 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