Anyone have any idea on the best way to pass a dat...
# suiteql
k
Anyone have any idea on the best way to pass a date through as a param to be used in a WHERE clause within the SuiteQL Query?
s
Using the
DATE
keyword, e.g.
DATE '2023-12-31'
TIMESTAMP '2023-12-31 12:00:00 UTC'
Copy code
SELECT id
FROM   transaction
WHERE  createddate >= DATE '2025-01-31'