I would like to create a filter for tickets created between certain times of day

Question

Does anyone have a formula for creating a filter that specifies a time range. Ie: Incidents created between 5pm - 9am

As we have night staff and day staff I need to create a dashboard for ticket timings between each team

KAGITHALA BABU ANVESH_z1zl10 · Answer

Hi @Joey Moroney ,

created >= startOfDay("17h") And created <= endOfDay("+9h")

I think the above will work, please check this

KAGITHALA BABU ANVESH_z1zl10 · Answer

Hi @Joey Moroney ,

createdDate >= "2021-01-21 17:00" and createdDate <= "2021-01-22 09:00"

But everyday have to change the date manually. will check if any  other solution is possible.