JQL to see if Date1 = Date2

Chris Harris_ettcvj

Hello,

I am trying to find all the issues that have Date1 = Date2.  So example would be

Project = ProjectX AND Type = Release AND Date1 = Date2

Of course it errors with Valid formats include: 'YYYY/MM/DD' etc

Is there a way to find issues in this scenario?

Mikael Sandberg

Hi @Chris Harris,

Welcome to Atlassian Community!

You cannot compare two fields in out-of-the-box JQL, you would need an app that extends JQL with a function that allows you to do that. Based on this thread it looks like Scriptrunner can do this, and you should check out all the other apps in the Marketplace that extend JQL.