JQL for X Days Since Start Date

[Alen Dumonjic]

Hello:

I'm trying to create a JQL for when exactly 80 days have passed since the Start Date on an issue. But all I've been able to come up with is issues with a start date in the last 80 days in the query below. What am I missing here?

project = TEST AND issuetype = "Task" AND "Start Date" = -80d 

Thank you all for your help. It's greatly appreciated.

[Andreas]

ok, since we don't have the "Start Date" field in our instance, I tried to find issues created exactly 2 days ago and was able to find them like this:

createdDate >= -3d AND createdDate <= -2d

So, assuming your Start Date works similar, this should give you all the issues in question:

project = TEST AND issuetype = "Task" AND "Start Date" >= -81d AND "Start Date" <= -80d

[Alen Dumonjic]

Hi Andreas:

I believe that includes issues within the last 2 days. I would like to find exactly 80 days ago.

Thank you.

[Andreas]

aaahhh...

try this

project = TEST AND issuetype = "Task" AND "Start Date" > startOfDay(-80d) AND "Start Date" < endOfDay(-80d)

[Alen Dumonjic]

Thank you. It's a valid JQL, but it's not showing an issue that I know was created 80 days ago as of right now. Perhaps at the end of the day it will. I will follow-up.