Relative date and time range

RT Users
1

Hello all,

I’m trying to create a custom search to query all tickets created over the last week, during a specific time range. The intent is to see what tickets were created by which shift. So, for example I would like to see: all tickets created, in the last 7 days, between 15:00 and 23:00.

I’ve figured out relative searches for days, and various time searches, but nothing combined. Has anyone had success with this? I figured it would be three different parameters, “created >7 days ago” AND “created > 15:00” AND “created < 23:00”, however RT defaults the time searches to the current day negating the specified date range.

Let me know if that left any confusion. Thanks in advance.

Nick

2

Actually found a solution, though rather rudimentary (I’ll gladly accept recommendations to improve).

( Created > '7 days ago 15:00' AND Created < '7 days ago 23:00' ) OR ( Created > '6 days ago 15:00' AND Created < '6 days ago 23:00' ) ... etc.