Hi, I am trying to find a query for pulling releases from 2 weeks ago and 4 weeks in the future.

[Bao Moua]

I also need it to be from Friday to Friday. For example if I were pulling data today I would need release dates from June 5th to July 17th. Any advice is greatly appreciated.

Thank you!

[Ste Wright]

Hi @Bao Moua 

Not a default JQL search option. The solution depends on your hosting type - are you Server or Cloud?

If Server, you could use an app like Scriptrunner to do this search. Scriptrunner has additional functions to search via version start and end date, so your query would look like:

project = ABC and fixVersion in startDate("after -2w") and fixVersion in releaseDate("before 4w")

^ If you're using Cloud however, these functions aren't available in this app. You're best to look on the Atlassian Marketplace though and try to find an alternative app with this JQL extension - for example, JQL Search Extensions appear to have at least a release date search function in Cloud - see their help pages here.

Alternatively you could look to pull this information out separately via the APIs :)

Ste