CODEWITHSUNDEEP
netsuitesaved-searches
Imran
Imran

Reputation: 93

NetSuite - saved search- dynamic date range formula

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....

Upvotes: 0

Views: 6054

Answers (1)

ehcanadian
ehcanadian

Reputation: 1784

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.

Upvotes: 2

Related Questions