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 to find issues due today (12:00am through 11:59pm)?

We have a due date field (called "DueDate") that has a date and time in it.

Is there a JQL statement that finds all issues that are due today? In my terminology, "today" means all twenty-four hours of whatever the current date is.

Example: if it's Feb. 15, 2019, then these are due today:

Feb. 15, 2019 at 1:09am
Feb. 15, 2019 at 4:15pm
Feb. 15, 2019 at 7:10pm

It would not find these:

Feb. 14, 2019 at 11:59am
Feb. 16, 2019 at 12:01am
Feb. 15, 2017 at 1:15am

Accepted answers

All comments

Victor Mutambuki

Jason,

See already answered and accepted questions.

https://community.atlassian.com/t5/Questions/eazybi-time-of-day/qaq-p/378683

Victor

That appears to be for a plugin called eazyBI, not a JQL statement.

Victor Mutambuki

Correct. I couldn't find a way to get a JQL without a Plugin.

I believe I found the solution:

DueDate >= startOfDay() and DueDate <= endOfDay()

Venugopala Naidu

Hi @Jason Freeman ,

Try this below query once

project = "xxxx" AND status in (backlog,"In Progress") AND Due date <=-24h

Venugopala Naidu

Hi @Jason Freeman

project = "xxxx" AND status in (backlog,"In Progress") AND Due date <=endOfDay()

Hi Venugopala Naidu

What is the query for the exact Due date column above to return those are over due ?

like : when Due date < today()

:-)

thanks

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-service-desk

jira-server