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
Hi @Jason Freeman ,
Try this below query once
project = "xxxx" AND status in (backlog,"In Progress") AND Due date <=-24h
project = "xxxx" AND status in (backlog,"In Progress") AND Due date <=endOfDay()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Jason,
See already answered and accepted questions.
https://community.atlassian.com/t5/Questions/eazybi-time-of-day/qaq-p/378683
Victor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That appears to be for a plugin called eazyBI, not a JQL statement.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Correct. I couldn't find a way to get a JQL without a Plugin.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I believe I found the solution:
DueDate >= startOfDay() and DueDate <= endOfDay()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That’ll be the one Jason!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can put an increment in the brackets
e.g. startOfDay("-1") or ("-1d")
see
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.