JQL for X Days Since Start Date

Question

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.

Alen Dumonjic · Answer

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.

Andreas_obxgjv · Answer

aaahhh...

try this

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

Alen Dumonjic · Answer

Hi Andreas:

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

Thank you.