SuiteQL Time Zones: Why Dates Shift by a Day
Diagnose SuiteQL dates that appear one day early or late by separating date-only values, timestamps and JavaScript time-zone conversion.
Date Functions
5 notes in this thread.
SuiteQL GROUP BY Month, Quarter and Year
Group SuiteQL results by calendar month, quarter or year while keeping the output correctly sorted across multiple years.
SuiteQL Date Binds: TO_DATE and TO_TIMESTAMP
Pass dates and timestamps safely to N/query SuiteQL using bind parameters, TO_DATE and TO_TIMESTAMP with explicit formats.
SuiteQL Date Filters: Current and Previous Month
Filter SuiteQL records by the current month, previous month or a custom date range without losing rows at time boundaries.
SuiteQL EXTRACT(YEAR FROM): Year and Month
Use EXTRACT(YEAR FROM date) and EXTRACT(MONTH FROM date) in SuiteQL to filter, group and compare NetSuite date fields, with TO_CHAR alternatives.