Does anyone know what the correct format is for Date/Time literals in SuiteQL, specifically for use in a WHERE clause filter? I tried searching in suite answers, but can't seem to find any examples or definitions. I have tried

'2021-02-01 11:00:00.0'

,

'2021-02-01 11:00:00',

'2021-02-01 11:00'

and even

'2021-02-01'

but always get a

Failed to retrieve data

error with the query.

use

TO_DATE()

ah, thanks, i hadn't thought to try that!