Skip to content
H›skcah
WritingTopicsAbout
Topic

Date Functions

1 note in this thread.

20 July 20264 minute read

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.

SuiteQLSQLDate Functions
H› skcah

Think differently. Look back to see forward.

RSSXGitHub

© 2026 Ryan Sheehy