nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Udo Brand

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)

All comments

Udo Brand

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-administration

jql