How to do a date search using current sprint's start and end date

Question

I have the following jql filter I use for finding issues created during a given time period.

Is there a way to replace the two createddate statements with the start and end dates of the current sprint? (something like createddate >= currentsprint.startdate)

project = HHP AND issuetype = Bug AND createdDate >= "2018/11/02" AND created <= "2018/12/08" AND status not in (Accepted) ORDER BY "Scrum Team", created DESC

Fazila Ashraf · Accepted Answer

Hi @[deleted]

Not as far as i know..

But if you follow some standard timeboxes for your every sprints, you could use it like below to get tickets created in last 2 weeks (assuming my past sprint was last 2 weeks):

project = HHP AND issuetype = Bug AND createdDate  >= startOfWeek(-2) and createdDate  <= startOfWeek()  AND status not in (Accepted) ORDER BY "Scrum Team", created DESC