The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to write the JQL for ReleaseDate > SystemDate

Matty
September 12, 2022

How to write the JQL for ReleaseDate > SystemDate. Any function in JIRA allows to compare a date field against systemdate?

3 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

2 votes
Eugenio Onofre
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
September 12, 2022

Hello @Vishnu

You can use the now() function to achieve it.
The JQL would be something like below:

project = XXXX AND ReleaseDate > now()

Regards,
Eugenio

Matty
September 13, 2022

This is not working. 

0 votes
Matty
September 13, 2022

I tried datecompare function from scriptrunner but still my usecase is not covered. I need to find the list of the Issues which are past Fixversion ReleaseDate. 

0 votes
Radek Dostál
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
September 13, 2022

There's no way to do date comparison out of box - you would require a jql function (supplied by a plugin) which would implement the necessary filtering logic in the background.

Edit: this was about comparing 2 different date fields, not a single field vs. any date functions that are available out of box

Comments for this post are closed

Community moderators have prevented the ability to post new answers.