SuiteQL EXTRACT: Get the Year and Month From a Date
Use EXTRACT(YEAR FROM date) and EXTRACT(MONTH FROM date) in SuiteQL to filter, group and compare NetSuite date fields, with alternatives using TO_CHAR.
SQL
2 notes in this thread.
SuiteQL Empty Strings Are NULL: Why Optional Filters Return No Rows
A blank SuiteQL parameter is not equal to an empty string. Learn why optional filters silently remove every row, how to reproduce the problem, and two reliable ways to fix it.