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 write the JQL for ReleaseDate > SystemDate

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 Leader Sep 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()


This is not working. 

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. 

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