How to compare two different time values using JQL

Question

Hello Everyone ,thanks for your time.

Our issue has two userdefined time values,one named  “planned finish date”，and the other is “actual finish date” .

Now my problem is i want to find the issues which “actual finish date”  is later than “planned finish date”.

When i use “actual finish date”  >=“planned finish date” in JQL,i got a  tip saying format error. Please tell me how to resolve this problem.

Niranjan · Accepted Answer

Hi @onionwang - JIRA's native JQL feature does not let you to compare dates, but with script runner you can do it. Try the below JQL (works only if you have script runner installed)

issueFunction in dateCompare("project = ABC", "updated > Resolved")