ANS-0853 · CUSTOM FIELDS, RECORDS & FORMS
How to Default a Custom Date Field to Two Weeks from Today in NetSuite?
Learn how to automatically set a custom date field's default value to 14 days in the future using a simple formula in NetSuite.
Short answer
To default a custom date field in NetSuite to two weeks from the current date, navigate to the field's Validation & Defaulting subtab. Enable the FORMULA checkbox and input SYSDATE+14 as the default formula. This configuration ensures the field automatically populates with a date 14 days from today.
Scenario
Users often require custom date fields in NetSuite to automatically populate with a future date, such as two weeks from the current day. Manually entering this date for every record can be inefficient and prone to errors. A common business requirement is to streamline data entry by defaulting such fields.
Solution
To default a custom date field to two weeks from the current date, follow these steps:
Navigate to the custom Date field's definition.
Locate the Validation & Defaulting subtab.
Check the FORMULA checkbox.
In the formula field, enter the following:
SYSDATE+14This formula instructs NetSuite to calculate the current system date (SYSDATE) and add 14 days to it, setting the result as the default value for the field.
Expert NetSuite Support
Need help with this NetSuite issue?
Custom Fields, Records & Forms consulting and configuration support