JQL to see if Date1 = Date2

[Chris Harris]

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 · Accepted solution]

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.

[Vamsi Kandala]

Hi @Chris Harris

Welcome to Atlassian community!

What @Mikael Sandberg meant was that Jira does not support comparing two dates which are custom fields in the JQL query.  You can use system date fields like 'created', 'updated', 'duedate', 'resolved' etc. to compare within the JQL query.

You can try comparing the custom date fields in the automation rules.

Thanks,
Vamsi