NetSuite - saved search- dynamic date range formula

5.6k Views Asked by At

Is it possible to write dynamic date range formula in NetSuite Saved Search? For example I have one of the expression in results tab is | case when {type} = 'Sales Order' and {custbody6} = 'F' then {amount} else 0 end | and I want to be able to add the dynamic date range to this like, and when {date} or {datecreated} is within 'last week' or 'last month' etc....

1

There are 1 best solutions below

4
On

There are many search date filters, such as thisWeek, lastWeek, etc. You can find them listed in NS help, under Search Date Filters. The filters are supported in formulas also.