filter with a time range (5 days per week, 8h per day)

Question

I am looking for filter that shows me only the tickes form 0800-1600 from Monday to Friday in a month.

Currently my filter looks like.

project in (xyz) AND createdDate >= "2017-12-01" AND created Date <= "2017-12-31" AND Service = abc ORDER BY created DESC

Now i have alle tickets form the Service abc.

How can a reduce this now to the 8h form Monday to Friday?

unknown · Answer

Also, you can use:

last 2 month: created > startOfMonth(-1)
created only in a specific month: created > startOfMonth(-2) and created < startOfMonth(-1)

Michael Hogak · Answer

it´s realy ugly but it works fine for 1 week  ;-)

thx a lot

unknown · Answer

It takes automatically the time you set for your instance, not 100% sure, but I would bet for it.