nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to query for issues that have a Target End in the past?

Sofie Palacios

For example, I would like to see all issues whose target end is from today backwards... if that makes sense.

Right now, it looks something like this, but this is clearly very incorrect...

"Target end" > startOfDay() AND "Target end" <= startOfDay(-0d)

Any help would be amazing!!

Accepted answers

Geethanjali Katagani

Hi @Sofie Palacios ,

For your requirement, the JQL "Target end < startOfDay()" should suffice based on your example. You can go ahead and remove " Target end > startOfDay() AND" and test. If you're looking for issues with a target end date that goes back from today, consider using the following JQL:

"Target end <= startOfDay()"

Thanks,

Geethanjali

All comments

Clark Everson

Hi A Sofie,

Based on your example question the JQL would be

"For example, I would like to see all issues whose target end is from today backwards... if that makes sense. "

"Target end" <= <span>startOfDay</span>()

Per my custom ChatGPT bot, I verified it works!

Best,

Clark

Mykenna Cepek

And to help with understanding how to do these kinds of date checks in JQL...

The original query:

"Target end" > startOfDay() AND "Target end" <= startOfDay(-0d)

when translated to words would be:

"Target end" date is after the most recent Midnight AND "Target end" is before or equal to the most recent Midnight.

No date is going to match both of those conditions. It's never true that A>B and A<=B.

- - - - - - -

Now you might want to ponder what you mean by "Today". That might be any of these:

The most recent Midnight
The time and date right now
The next Midnight

The JQL equivalents for the above, in order, are:

startOfDay()
now()
startOfDay(1)

Geethanjali Katagani

Hi @Sofie Palacios ,

"Target end <= startOfDay()"

Thanks,

Geethanjali

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-software

jira-software-server