JQL Question: Isssues created before 8am today and created after 5pm today?

[Anand Unadkat]

After 5pm today >> created >= endOfDay (-7h) ??

Before 8am today >> created <= startOfDay (8h) ??

Thanks

[Udo Brand · Accepted solution]

with startofday:

After 5 pm: created > startofday("+17h")

before 8 am created < startofday("+8h")

or with endofday:

After 5 pm: created > endofday(-7h)

before 8 am created < endofday(-16h)

[Anand Unadkat]

Thanks @Udo Brand however you cannot use '+' character in the jql. Already tried that. At the moment I am using After 5pm today >> created >= endOfDay (-7h) Before 8am today >> created <= startOfDay (8h)

[Udo Brand]

You can use '+' but you need to put it in quotes, see my examples. However, what you are currently using works also. But does it make sense? Are you trying to find issues that where entered during non office hours?

[Anand Unadkat]

Ah makes sense. Thanks mate! :) Yeah I am trying to find all the issues that are created during office hours and outside office hours. :)