Can JQL give me a day count between due and endOfDay()?
My task is to set up a query that would asign red colour to a card that is not likely to be completed on due date. So, I'm trying:
due < endOfDay(arg)
where arg is equal to:
remainingEstimate/60/60/6
I figure that since time in JIRA is calculated in seconds, I convert it to minutes (/60) to hours (/60) to days (day has 6 hours in my case), I should get a number (not sure if it must be an integer though...)
Anyhow, my function doesn't give expected results.
Any ideas?
Hi,
I'm guessing you want something like this:
duedate > endOfDay(-5d)
This gives you all issues that have a duedate expiring within five days of the current end of day. You can adjust the number in the parenthesis as you want.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.