How to run a saved search and limit results to the last few hours

AI generated answer (using internal Slack threads):

To run a saved search and limit results to the last few hours, you can use a Formula (Numeric) criteria filter in your saved search. The formula

{today} - {createddate}

returns the number of days elapsed as a floating point value. You can then filter on results

less than or equal to

value

1

to get the last 24 hours. If you need a different range, you may need to use a between filter. For example,

between

0.125

and

1.125

would return everything that was created more than 3 hours and less than 27 hours ago. For a fixed time range, you can use

to_date('2019-10-10 19:00', 'YYYY-MM-DD HH24:MI') - {createddate}

, which calculates the time elapsed from the Date Created until a specific time. If you want to see the time portion of {today}, you can use a Formula (Date/Time) column with {today}. If using Formula (Date), it will not show the time portion. Alternatively, you can use the

TO_CHAR

to convert {today} to a string:

TO_CHAR({today})

The function takes an optional second parameter where you can specify an output format, otherwise it uses a default format. For a specific time range every day, you can 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') > '15:00:00' AND TO_CHAR({datecreated}, 'HH24:MI:SS') < '16:00:00' THEN 'T' ELSE 'F' END

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******