Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
NetSuite has launched SuiteSuccess Wholesale Distribution Edition, in Japan. Please join us the webinar on February 12 that introduces NetSuite solution with demos and case studies for Wholesale Industry.
Register Now
Have questions or experiences to share? Post your Release 2026.1 questions and join discussions in the Release 2026.1 category.
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
👑 Call for Nominations: NetSuite Support Community Choice of the Quarter – Q1 2026
Recognize a member who made a difference in our community!
