Forums

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

How to write the JQL for ReleaseDate > SystemDate

Vishnu 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

2 votes
Eugenio Onofre
Community Champion
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

Vishnu September 13, 2022

This is not working. 

0 votes
Vishnu 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 Leaders.
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

Suggest an answer

Log in or Sign up to answer