JQL day count

[Arthur]

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?

[SanaS]

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.