Report for Tasks and Incidents within certain hours

[Ivan Williams1]

I would like to create two reports; one for Incidents and one for Tasks. But, in particular, I would like to see on my report all Incidents and Tasks closed between 17:00 - 19:00, daily. 

But, my report does not seem to pull JUST that time frame, i.e. 17:00 - 19:00 daily. Any ideas...(see attached image)?

Thanks 

[Uncle Rob]

You want to use the TREND operator, because "between" assumes fixed date-times.

I made a short video explaining this operator not too long ago.  Check it out here

[Ivan Williams1]

Great video. One additional comment, if you review my image below, I am trying to get two things: 

- a report between 1st May - 31st May

- trend between 17:00 - 19:00

I tried putting the trend after the dates, that did not help. Tried the other way round, that did not help.

Any ideas? Thanks.... 

[Uncle Rob]

"Didn't help" in what way?  Are there tasks you can identify that should have been caught but weren't?

One thing I'd say is you should be using "On or after" / "On or before".  Not "after / before".  I'd also strip out your group conditions until you're certain your getting your timing conditions met.

[Ivan Williams1]

To be clear, I would simply like to create a report that will show me Incidents worked Monday to Friday ONLY between the hours of 17:00 - 19:00. 

What is the best way to accomplish this? Based on what I have tried thus far (from my image previously posted), the report is not solely calculating between 17:00 - 19:00. 

Thanks all...