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

Saved search criteria by time only - trying to create a search to see transactions created between a set time every day i.e 15:00 to 16:00 pm every day for two weeks (not whole two weeks duration) how can I restrict my results for this? To be clear it is to see transactions created between that timeframe and not date range

I did something similar in SuiteQL - a quick adaptation to a saved search seems to be working. Add a Date Created filter for the last two weeks and then a separate filter on Formula (Text) = T where the formula is:
CASE WHEN TO_CHAR({datecreated}, 'HH24:MI:SS') &gt; '15:00:00' AND TO_CHAR({datecreated}, 'HH24:MI:SS') &lt; '16:00:00' THEN 'T' ELSE 'F' END

Thanks <@U04LBDELABG>... like this? don't seem to be getting any results?

you seem to be missing the comparison part