How can I see epics older than 90 days and still open

[GrapeApe]

I've created this query which shows me all open epics that are 90 days or older. However it still includes epics from september, august, july.. today is october 1st. I want to exclude anything created within the last 90 days I just want to see what's still open from 91 days and on. 

issuetype = Epic AND createdDate >= 90 AND status not in (accepted, rejected) ORDER BY created DESC

I also tried this: 

created >= startOfDay(-90d) AND issuetype = Epic AND resolution = Unresolved ORDER BY created DESC

However it literally just gives me anything created within the last 90 days not older than 90 days

[GrapeApe · Accepted solution]

Nevermind figured it out using the two queries above and combining them

 issuetype = Epic AND createdDate >= 90 AND status not in (accepted, rejected) AND created < startOfDay(-90d) ORDER BY created DESC

[Trudy Claspill]

Hello @GrapeApe 

There is a problem with your query.

"createdDate >= 90" is not really meaningful. It is trying to compare a date (createdDate) to the value 90. I'm not entirely sure what is happening behind the scenes, but that is not evaluating the time passage since the creation of the issue in the way you want.

So, looking at your query you need to eliminate the AND createdDate >= 90 portion of the query.

Also, if you want to find issues that were created more than 90 days ago you need to use < (less than) rather than > (greater than).

Let's say you want to find issues more than 3 days old.

-3d = 9/27/2022

created Date = 9/26/2022

9/26/2022 < 9/27/2022  TRUE

createdDate <= -3d  TRUE

created Date = 9/30/2022

9/30/2022 <= 9/27/2022  FALSE

If you use createDate > value then you are asking for issues where Created Date is newer than value.