NSC | How to Create a Custom Field That Calculates Age

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)