Discussions
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)
@Red Velasco-Oracle | Suite Builder Guru |🦖T-Rex
👑 Q4 2025 Community Choice Nominations:
Recognize a member who made a difference in our community!
