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.

[Alper Saglam _actioner_ · Accepted solution]

Hi @Ragavendran S 

I think giving credit to the previously asked question. comparing the target end with startOfDay() like below

"Target end" < startOfDay()

and your JQL will be like this:

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

will work for you.

What do you think? I hope this is what you asked.

Alper-
from Actioner

[Dexter de Vera · Accepted solution]

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!

[Ragavendran S]

I attempted that solution before asking here, yet the issue persists, particularly the one with today's target end date.

[Dexter de Vera]

Can you give us some screenshot of your filter. And view of the ticket including target end field?.

Note: Make sure you use the correct name of the date field. 

[Ragavendran S]

[Ragavendran S]

Sorry, there was some misunderstanding. since the start date is in May, and the end date is in Apr, it listed the issue. closing the question. Thanks @Dexter de Vera for trying out to resolve this issue. much appreciated 

[Dexter de Vera]

Yes.. Today is May not April. :)

Thanks!

[englund_david]

@Dexter de Vera, what if you wanted a range, like moving from (AND resolved >= "2025/06/01" AND resolved <= "2025/06/05") to something that you don't have to change each time you run it. Like, (resolved >= NOW-5 AND resolved <= NOW)? Is there a correct way to do that? So, no matter when you run the filter it will always give you results for the last five days?