How do I compare two date fields when writing a JQL

Question

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.

Gosia Adamska · Answer

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)

Aron Gombas _Midori_ · Answer

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.