How to Use the BUILTIN.PERIOD in Netsuite SQL

32 Views Asked by At

According to this documentation: Period - Returns the contents of the IN predicate for a relative date range as a subselection

I am not sure on how to use this one, and already tried every format, and I also tried this thread: but no hope.

So far, here's what I tried:

require(['N/query', 'N/log'], function( query, log ) {
 var q = "select startdate from transaction where startdate IN(BUILTIN.PERIOD('LM', 'START', 'ALL', '<'))"
 var rs = query.runSuiteQL( {
   query: q
 });
 var mRS = rs.asMappedResults();
 console.log(mRS);
})
0

There are 0 best solutions below