Setting due date JQL basing on created date

[Ta Minh Thuy]

Hello all,

I'm strugging with writing a JQL using due date.

I used JIra mics workflow to automatically set due date for the issue when it is created 5 days and nobody starts working on it yet.

Automated Due Date based on Create Date (+5 Days)

Now I need to create a filter to list all issues that have Due in less than 3 days & Due passed 3 Days - 14 Days.

Please help!

[John Funk]

Hi @Ta Minh Thuy ,

If you use: project = ABC and duedate <= startOfDay(3) and statusCategory != Done

that will show you everything that is already past due or due within the next 3 days. 

[Ta Minh Thuy]

Thank you so much Mr. John!