Let’s say you’re storing birthdates on employee or customer records and need to display their current age without calculating it manually. Instead of exporting data to Excel, you can create a custom formula field that automatically calculates age based on the birthdate and today’s date. This helps you keep real-time age data visible on the record—perfect for reports, segmentation, or internal processes.
Navigate to Customization > Lists, Records, & Fields > Entity Fields > New
Enter the formula In the Default Value / Formula field, enter a formula that calculates the age. Make sure Store Value is unchecked.
FLOOR((TO_DATE({today}) - TO_DATE({custentity_dob}))/365.25)
- {custentity_dob} should be replaced with the internal ID of your Date of Birth field.
- 365.25 accounts for leap years.
- FLOOR ensures the age is rounded down to a whole number.
Click Save to apply changes.