suitesql get all records that were created today

AI generated answer (using internal Slack threads):

To get all records that were created today using SuiteSQL, you would need to use a WHERE clause in your SQL statement to filter the records based on the

datecreated

field. Here is a general example of how you might structure your SQL query:

sql
SELECT * 
FROM YourTable
WHERE TO_CHAR({datecreated},'YYYY-MM-DD') = TO_CHAR(CURRENT_DATE,'YYYY-MM-DD')

In this query,

YourTable

should be replaced with the name of the table you are querying. The

TO_CHAR

function is used to format the

datecreated

field and the current date to a string in the format 'YYYY-MM-DD'. This allows you to compare the dates without considering the time. Please note that this is a general example and you might need to adjust it based on your specific requirements and the structure of your NetSuite data. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******