This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello, I am attempting to create a saved search via the UI for Scripts that execute during a specific date and time frame. I have added logging to all my functions during the script execution but I only want the results of script logs to be within the timeframe that I have specified. I see there isn't a time option when adding the filter by date. Any ideas how I can get this done? I was thinking the Formula (date) might work best.

use a formula like `TO_DATE('4/13/2020 4:36:13 PM', 'DS TS') - {time}` and compare the resulting number of days to some value

you could also potentially use  a CASE statement and use something like the <https://docs.oracle.com/cd/B28359_01/server.111/b28286/conditions011.htm#SQLRF52147|BETWEEN> condition or use less than or greater than