Suppose you have a field in a record which displays date for a perticular event/process. You are required to prepare a report using workbook in which one of the fields is days since the date given in the corresponding record.
Say for example) In the sales order record, Order Date = 23-May-2025. I have to find the order days ie, no of days since order date. In that case add a formula field in the dataset. Netsuite offers a function called CURRENT_DATE. Now apply the following formula:
TRUNC(CURRENT_DATE)-TRUNC({order_date_field_id})
