Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to add advanced filters to find issues not created in the last 90 days.

amrita.sodhi August 6, 2021

How to search for issues not created in the last 90 days.

 

In other words, how do I search for issues older than 90 days to see which ones are aged tasks.

 

 

1 answer

1 vote
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 6, 2021

The JQL clause created < -90d will find all issues created over 90 days ago. 

The way we write clear English that sentence above does not quite explain the JQL though,

if I were to write the JQL as it looks, it would be more like "show me issues that have a created date less than 90 days ago", and to understand that you have to understand how computers think of dates - they're actually holding a simple counter of "seconds elapsed since a base date", so the larger the number, the later the date/time.  That enables us to use operators like < and > on dates to compare them.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events