Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to use the releaseDate function for a specific day of week


Hello, I'd like to use the JQL function releaseDate to target a specific day in the week, for example Tuesday of the current week without having to specify a specific day.  This is used to dynamically populate a dashboard that shows all the issues scheduled for release on each day of the current week.

Basically, I want to write the equivalent of:

fixVersion in releaseDate("after startOfWeek('+1d') before startOfWeek('+2d')")


3 answers

1 accepted

1 vote
Answer accepted

You can do this, but from my testing, you need to count backwards.

For instance, if I want all issues that have a fix version release date on Thursday, I'd write:

fixVersion in releaseDate("on endOfWeek(-2d)")

If I want all issues that are going to be released on Tuesday:

fixVersion in releaseDate("on endOfWeek(-4d)")

Screen Shot 2017-08-16 at 12.37.39 PM.png

That works great.  It seems like the issue was the single quotes I was adding around the parameter to startOfWeek() that was causing the error.

Like Stephan Rothämel likes this

i am attempting to follow the logic here and am unable to produce any results. i am attempting fixVersion in releaseDate("after 2019-01-01 before 2019-09-15") and am just getting errors. do you have any suggestions for overcoming this? thanks in advance for your help. 

@Ryan Anderson , you can try to your case:

fixVersion in releaseDate("after 2019-01-01") and fixVersion in releaseDate("before 2019-09-15")
Like Ben Admin likes this

Unfortunately, this does not work. Error below:

  • Unable to find JQL function 'releaseDate(after 2019-01-01)'.
  • Unable to find JQL function 'releaseDate(before 2019-09-15)'.

@Whitney Patterson , you should add an "". 

releaseDate("after 2019-01-01"
releaseDate("before 2019-09-15")
Like # people like this

@Alexander Bondarev Thank you, I did use quotations previously - I copy and pasted the query. See screenshot below. Same error. Is there something I am missing?jql query.JPG

Wow! I checked on 3 Server instances - it's right.

But when I checked this query on Cloud - I got your error. 

@Whitney Patterson , so you are an Jira Cloud user? 

Like # people like this

Interesting that JQL-syntax checker think that it is right query... 

Try to ask that on Atlassian Support Portal. very interesting...


I checked list of JQL Cloud improvements here - there is no similar task.

Like # people like this

@Alexander Bondarev Ah, good point! Yes I am on Jira Cloud. Thank you for digging deeper - I will definitely reach out to Support.

Like Ben Admin likes this

@Whitney Patterson I am curious, did you hear anything from support on this issue? I would love to make this query work and I am on cloud as well.

Like # people like this

I am on Jira cloud and I am having the exact same problem that @Whitney Patterson was having. I would love to have a solution for this problem. Is there a fix or an alternative?

EDIT - Oh, it seems the official position of Atlassian is, "No."

I have not received any help yet, but will be trying again. Still no solution for Jira Cloud.

hi all, the "in releaseDate()" functionality is not native Jira, it comes from scriptrunner ;) 
So if you don't have scriptrunner, you can't use this query. 

See doc here

Is there any way to have the Release Date displayed as a column in my query output? I want to see the Release Date connected to each of the JIRA cards I have listed.  Thanks

Here is the query >>> fixVersion in unreleasedVersions() AND sprint in openSprints()

@Casey Maynard 
Did you find the answer ?

Did you got a solution?

@Henk Smets Unfortunately No, I have not.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

Online AMA this week: Your project management questions answered by Jira Design Lead James Rotanson

We know that great teams require amazing project management chops. It's no surprise that great teams who use Jira have strong project managers, effective workflows, and secrets that bring planning ...

190 views 1 6
Read article

Atlassian Community Events