Does anyone know how to get the ISO week of year for a given date in suiteql

Have you tried

TO_CHAR({date}, 'IW')

?

I think thats the one. Thanks!

@Cory Weiner Here's a comprehensive list of the datetime format elements that are supported. I do believe that SuiteQL supports all of them: https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements004.htm