Need help with JQL query

[Aisha M]

I am trying to search for issues (Epic) that have a Due date which are over 10 days but less than 20 days 

So between 10 days to 20 days

How do I search for it ?

Thank you !

[Sreenivasaraju P]

Hi @Aisha M ,

Please try with below query.

project = EPIC AND duedate >= 10d and duedate <= 20d

[Aisha M]

@Sreenivasaraju P Thank you for the reply.

I'm looking for Epics that are in the past, like 10-20 days past their completion date. How do I query that ?

Example _

An issue has Duedate of 1st May . . 

The above query is showing me issues that has  a due date in the next 10 days. 

[Sreenivasaraju P]

hi @Aisha M ,

ex :- today date is 11th May, do you want the tickets whose due date is between 1st May to 31st May . Is my understanding correct ? if yes, please use below query.

project = EPIC AND duedate >= -10d and duedate <= 20d

[Aisha M]

@Sreenivasaraju P 

Sorry for an unclear example.

I am looking for Epics whose Due date has already been completed, 10-20 days old from their mentioned due date. I am trying to filter those old epics with completed due dates. 

[Sreenivasaraju P]

project = EPIC AND duedate >= -20d and duedate <= -10d

[Aisha M]

@Sreenivasaraju P Hi, I think it worked. Thank you

Also, I tried searching for Epics with Due dates which are over 30days old.

But when I try duedate >= -30d   It does not work properly. Any idea why ? It also show shows that has a due date in the next 30 days