How to get report of all incidents opened after a certain time of day

[Eric K3]

I have a manager who would like a report of all incidents opened after 5 PM. Will I have to somehow parse the opened_at field? Or is there an easier way of doing this?

[Michael Fry1]

You should be able to report on just the Opened field. I would probably say use between. Opened yesterday 17:00:00 and today 08:00:00. That will give you ticket between 5pm and 8am.

[srinivasthelu · Accepted solution]

Hi Eric,

You need to use Trend filter on Opened field. Hope that helps

[Cameron Boote]

Use the Opened field

Opened - Trend - After 5PM

or

Opened - Trend - Before 8AM

[Eric K3]

Thanks all. I suppose I will remember to click though all the options before I ask the question in the community next time.