suiteql query to get the po records based on the last modified date

AI generated answer (using internal Slack threads):

To get the Purchase Order (PO) records based on the last modified date using SuiteQL, you can use the

lastmodifieddate

field in your WHERE clause. Here is a basic example of how you can structure your SuiteQL query:

sql
SELECT * FROM transaction 
WHERE type = 'PurchOrd' AND lastmodifieddate >= TO_DATE( '2020-11-24 00:00:00', 'YYYY-MM-DD hh24:mi:ss' )

In this query, replace

'2020-11-24 00:00:00'

with the date and time you want to use as your starting point. The format for the date and time is

'YYYY-MM-DD hh24:mi:ss'

. If you don't need the time precision and only want to compare the date, you can use the following format:

sql
SELECT * FROM transaction 
WHERE type = 'PurchOrd' AND lastmodifieddate >= TO_DATE( '2020-11-24', 'YYYY-MM-DD' )

Please note that the

type

field is used to filter the transactions for Purchase Orders (PurchOrd). ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******