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

[Jason Freeman]

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

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

[hanang]

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

[Victor Mutambuki]

Jason,

See already answered and accepted questions.

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

Victor

[Jason Freeman]

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.

[Jason Freeman]

I believe I found the solution:

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

[Tom Lister]

That’ll be the one Jason!

[Martha Dobrowolska]

What do we include in the brackets after startofday?

[Tom Lister]

You can put an increment in the brackets

e.g. startOfDay("-1") or ("-1d") 

see

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-startOfDaystartOfDay--