how to restrict records in NetSuite saved search from 9.30 AM yesterday to 9.30 AM today

AI generated answer (using internal Slack threads):

To restrict records in a NetSuite saved search from 9.30 AM yesterday to 9.30 AM today, you can use a combination of date and formula filters. Firstly, you need to add a Date Created filter for the last two days. This will ensure that you are only looking at records created within the last two days. Next, you need to add a Formula (Text) filter. This filter will allow you to specify a condition that the record must meet in order to be included in the search results. In this case, you want to include only records that were created between 9.30 AM yesterday and 9.30 AM today. The formula for this filter would be:

CASE WHEN TO_CHAR({datecreated}, 'HH24:MI:SS') > '09:30:00' AND TO_CHAR({datecreated}, 'HH24:MI:SS') < '09:30:00' THEN 'T' ELSE 'F' END

This formula checks the time portion of the Date Created field and compares it to the specified time range. If the time the record was created falls within this range, the formula returns 'T' (true), and the record is included in the search results. If the time the record was created falls outside this range, the formula returns 'F' (false), and the record is excluded from the search results. Please note that the time format used in the formula is in 24-hour format, so 9.30 AM is represented as '093000'. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******