As a NetSuite user, there may be scenarios where displaying both the day of the week and the current date on transaction records (such as Sales Orders, Purchase Orders, or Invoices) is helpful for internal processes, reporting clarity, or workflow automation.
For example, if your business operations or shipping schedules depend on the day an order is placed (e.g., avoiding weekend processing), it can be valuable to have this information visible directly on the record. Instead of manually checking or calculating it, you can automate this by using a custom field. To do this you can follow steps below:
1. Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New
2. Label: < Enter preferred field label>
3. Type: Select Free-Form Text
4. Store Value: Remove Checkmark
5. Click Applies To Tab
- Select preferred Transactions: Enter Checkmark
6. Click Display Tab
- Display Type: Select Disabled
7. Click Validation & Defaulting Tab
- Formula: Enter Checkmark
- Default Value: Enter SUBSTR((to_char({today}, 'Day')), 0, 3) ||' '|| {today}
8. Click Save
Note:
If today's date is 10/29/2025, the value of the field is Wed 29-OCT-2025. The formula can also be used for other kinds of fields like Entity, CRM and Item fields.