Forums

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

How do I compare two date fields when writing a JQL

Jomil Villareal
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 20, 2024

Hello! 

I have two field dates, resolved and due

I would like to compare these to get the issues where resolved > due so that we can track which tickets that are closed are overdue tickets.

This is mostly for tracking and dashboard purposes. 

We previously used issueFunction in dateCompare in the old JIRA, but I dont think these functions are available on JIRA Cloud anymore. 

2 answers

0 votes
Gosia Adamska
Contributor
November 20, 2024

Hi. Agree with Aron. It's not directly possible but you may create a workaround for it thru automation. Here is a post on how to do it :

Formula to compare Due Date to Resolved Date (atlassian.com)

0 votes
Aron Gombas _Midori_
Community Champion
November 20, 2024

I am afraid you can't use the "<" operator between two fields. One argument must be a constant or JQL function.

There may be third party workarounds though.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events