Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you