JQL to find issues due today (12:00am through 11:59pm)?

Jason Freeman February 15, 2019

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

2 answers

0 votes
Venugopala Naidu February 15, 2019

Hi @Jason Freeman ,

Try this below query once 

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

Venugopala Naidu February 15, 2019

Hi @Jason Freeman

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

Like Ludvig Hede likes this
hanang June 20, 2022

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

0 votes
Victor Mutambuki [Mumo Systems]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 15, 2019

Jason,

See already answered and accepted questions.

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

Victor

Jason Freeman February 15, 2019

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

Victor Mutambuki [Mumo Systems]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 15, 2019

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

Jason Freeman February 15, 2019

I believe I found the solution:

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

Like # people like this
Tom Lister
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 17, 2019

That’ll be the one Jason!

Martha Dobrowolska November 26, 2021

What do we include in the brackets after startofday?

Tom Lister
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 6, 2021
Like Martha Dobrowolska likes this

Suggest an answer

Log in or Sign up to answer