Real work day JQL

Question

Hi,

My work times are from 8 - 5pm.  Any ticket that comes in at say 5:01PM needs to be counted on the next day.  So, how do I write a JQL to show me all tickets starting at 5:01PM until 5:00PM the next day?

Mikael Sandberg · Accepted Answer

You would have to use a JQL with specific dates and times in order to do it, something like this:

(created >= "2023-02-03 17:01" AND created <= "2023-02-04 17:00")

Trudy P Claspill · Accepted Answer

You could use this filter:

created >= startOfDay(-7h) and created <= startOfDay(17h)

...to get all the issues created since 5pm yesterday up until 5pm today.

Craig Nodwell_7eve9b · Accepted Answer

Use the jql @Trudy P Claspill gave you below.

created >= startOfDay(-7h) and created <= startOfDay(17h)

This will give you what you want, save it as a filter and you can use it in your dashboard gadgets.

henry cavill · Accepted Answer

This filter is a possibility:

To obtain all the issues produced from 5 p.m. yesterday until 5 p.m. today, use the criteria created >= startOfDay(-7h) and created = startOfDay(17h).