Filter date and time (out of hours)

[Carl Ekholm]

Hi!

Im trying to get a filter working for issues updated the current year, from 17:00 and later, until the next day not later then 08:00.  This is meant to show how many issues were created during "out of hours", a.k.a the night staff.

So far, i've written it like this, which gives me correct results, but only for the last day. I want the search to include ALL days, from either startOfYear or any given date. Is there a way to do this?

project = "123" AND updated > startOfDay("-7h") AND updated < startOfDay("+8h")
 

[Sergey Sukhaninskiy · Accepted solution]

Hi.

Why you use "updated" if you need "how many issues were created during "out of hours""? 

Try use "created".

For all days, you need use plugin like ScriptRunner for Jira

http://scriptrunner-docs.connect.adaptavist.com/jiracloud/enhanced-search.html#_dates 

Or special for reports eazyBI Reports and Charts for Jira

[Carl Ekholm]

Thank you!

And - Updated was my intention, created was a typo :)