Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,369,277
Community Members
 
Community Events
168
Community Groups

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

2 answers

Hi @Jason Freeman ,

Try this below query once 

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

Hi @Jason Freeman

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

Like Ludvig Hede likes this
hanang I'm New Here Jun 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

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

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()

Like # people like this
Tom Lister Community Leader Feb 17, 2019

That’ll be the one Jason!

What do we include in the brackets after startofday?

Suggest an answer

Log in or Sign up to answer