nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Aron Gombas _Midori_

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.

All comments

Aron Gombas _Midori_

You can not do arithmetic in JQL, unfortunately.

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

jql

date