Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
How to use BUILTIN.PERIOD in SuiteQL?
I am using jdbc to run queries.
I wanted to use the builtin.period. but am not sure exactly.
I want to do something liker this
select * from revenuePlanPlannedRevenue where BUILTIN.PERIOD('LM', 'END', 'NOT_LAST', '=');
this table has two period columns. However from the documentation, I do not see how to reference it.
I have tried different variations, but ai just get a syntax error from SQL.
I am using Answer ID99191
Tagged:
0