How to find out issues where two custom field's dates must be matched.

[Deepika singh]

Hi ,

I want to find out the issues where "Dev complete commitment date(custom field)" doesn't equal to "Actual Dev delivered date(Custom field)".

Thanks in advance.

[John Funk]

Hi Deepika,

There is an Advanced Compare condition in Automation for Jira that might provide what you need. Here is more information on Automation if you are not familiar with it:

There are two types of automation:

• Global: In the Free version, you get 100 executions per product, per month
• Project: In all versions, you get unlimited executions per month

Automation Basics: https://www.atlassian.com/software/jira/guides/expand-jira/automation

You can do this via global rules to apply to all projects also. You'll need to be a Jira Admin/Site Admin, go to Jira Settings > System > Automation Rules (left-hand menu).

For more on using Automation For Jira see these help pages.

Jira Automation Template Library to help get you started quickly:

https://www.atlassian.com/software/jira/automation-template-library#/labels/all/customLabelId/1453

[Tansu Akdeniz]

Hi @Deepika singh 

By default, it is not possible to do it. If you have Script Runner or Enhanced Search add-on, you can use dateCompare function. Alternatively, you can use BI add-ons to make calculations.

[Deepika singh]

Hi @Tansu Akdeniz 

Got it, but these add-ons are quite expensive. 

Is there any other alternative?

[Tansu Akdeniz]

As I know, there is no free solution unless you develop a custom add-on.