Modules

filter

 

Objects/Functions

module (N/query)

SuiteScript 2.0

query.RelativeDate

// Please search https://system.netsuite.com/app/help/helpcenter.nl?search=query.RelativeDate for more information.

N/query Module
query.RelativeDate
Object Description: A relative date to use in query conditions. Use query.createRelativeDate(options) to create this object. After you create this object, you can use it in the values parameter of Query.createCondition(options) or Component.createCondition(options). This object represents a specific moment in time, and you can use it to create query conditions using operators from the query.Operator enum, such as query.Operator.AFTER, query.Operator.BEFORE, and query.Operator.WITHIN. For more information about relative dates, see Relative Dates in the N/query Module.
Supported Script Types: Client and server scripts For more information, see SuiteScript 2.0 Script Types.
Module: N/query Module
Methods and Properties: RelativeDate Object Members
Since: 2019.1
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=query.RelativeDate

Example:

// Code Example 1
// Add additional code
//...
var myEndDate = query.createRelativeDate({
dateId: query.DateId.WEEKS_AGO,
value: 2
});

var myComplexCondition = myQuery.createCondition({
fieldId: 'trandate',
operator: query.Operator.WITHIN,
values: [query.RelativeDateRange.THREE_FISCAL_YEARS_AGO.start, myEndDate]
});
//...
// Add additional code

//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_1544109440.html