Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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