suiteql query to compare trandate with with today

AI generated answer (using internal Slack threads):

To compare

trandate

with today's date in SuiteQL, you can use the

CURRENT_DATE

function. Here is an example of how you can do it:

sql
SELECT * FROM transaction 
WHERE type = 'SalesOrd' 
AND TRUNC(trandate) = CURRENT_DATE

In this query,

TRUNC(trandate)

is used to remove the time part from the

trandate

and

CURRENT_DATE

is used to get the current date. This will return all sales orders where the

trandate

is today. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******