Filter for getting Date Past Target End Date

Ragavendran S

Currently, we have automation rules in place that trigger an email notification if an issue remains incomplete past its target end date.

We utilise a filter to pinpoint issues; however, this filter also retrieves issues where the current date matches the target end date.

Filter Query:  project = "XYZ" AND Status not in (closed, done, "Not Covered") AND "Target end" < now()

 

I need assistance with filtering tickets that are past the due date, excluding those where the due date matches the current date.

For example: (Assuming Current Date is today 9-May-24)

Example 1:

Target End Date: 9-May-24
Status: Open
Expected: Should not be filtered in results because the current date is the same as the target date. It should appear in results when the current date is the 10th of May or later.

Example 2:

Target End Date: 8-May-24
Status: Open
Expected: Should be filtered in results.

Dexter de Vera

Hi @Ragavendran S ,

You can update your JQL  like this:

 project = "XYZ" AND Status not in (closed, done, "Not Covered") AND "Target end" <= -1d

This filter will allow you to search issues past the Target end excluding current date.

 

Hope it helps!