How to check if "end date minus start date is >= 30 days"?

[Sascha Wiltenburg]

Hi community, been trying to use automation rule for check if "end date minus start date is >= 30 days". Unfortunately somehow not managing to get this by JQL alone, is this even possible? If not, any suggestions?

(btw, using custom fields 'Start Date' / 'End Date' for this)

Regards, Sascha

[Aron Gombas _Midori_ · Accepted solution]

You can not do arithmetic in JQL, unfortunately.

What you could do is introducing a new custom field "Duration" and update that with the end_date minus start_date value every time when one of those changes and both are available. It can be done with Automation for Jira using a single automation rule. Or you can do this with a scripted field, there are many apps for that.

Then you test if that field is < 30 in JQL. 

[Sascha Wiltenburg]

Thanks for the swift response, could you elaborate on 'update that with the end_date minus start_date value every time when one of those changes and both are available. ', possibly with an example even?

[Aron Gombas _Midori_]

Do you have Automation for Jira installed? (it is a requirement for this approach)

[Sascha Wiltenburg]

Yes, I have automation for Jira installed and created a custom field as mentioned above