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; } } }

Calculate business days between start date and due date, then insert into new issue field

patricia.ambichler

Hello all!

I'm struggling with a jira automation on a business board.

The issue fields concerned:

* Due date

* Start date (as far as I can see, it was created by a jira admin)

* Length (I've tried a number and text field)

Goal: when an issue is updated, start and due dates are both not empty, then calculate the business days between them and insert them into the new field "Length". Format of output is irrelevant (eg 5, 5.0, 5 days) - everything goes.

Smart value I have tried:

Also with issue field IDs and calculation {{#=}} & {{/}}

Accepted answers

Trudy P Claspill

Hello @patricia.ambichler

Welcome to the Atlassian community.

Whenever asking for help with an Automation rule, it will help us help you if you provide screen images showing the complete rule and the details of each step.

In the case where the rule is not doing what you expect it will also help us if you provide all the details from the rule Audit Log for a time when the rule executed, and if you tell us what you expected the specific result to be and what the actual result was.

Lastly, when using smart values the field names you use in them are case sensitive and space sensitive. If "Due date" and "Start date" are the field names you see in the screen, then try using

All comments

Trudy P Claspill

Hello @patricia.ambichler

Welcome to the Atlassian community.

Whenever asking for help with an Automation rule, it will help us help you if you provide screen images showing the complete rule and the details of each step.

Lastly, when using smart values the field names you use in them are case sensitive and space sensitive. If "Due date" and "Start date" are the field names you see in the screen, then try using

patricia.ambichler

Hello @Trudy P Claspill , thank you so much!

I've tried various versions of the smart value, including "Due date" and the IDs.

I don't know how much the audit log will help, as it says "success" but the issue field Length never changes.

patricia.ambichler

Does it matter, what type of field Length is?

Trudy P Claspill

Text or number should be fine for the Length field.

A debugging technique that is available to you is to use the Log action to print into the rule Audit Log the values of the smart values you are trying to use. That will help you determine if the right information is being obtained from the issue.

Screenshot 2024-07-04 at 11.52.38 PM.png

If you can do that and run the rule again, and provide the requested screen images, and an image of the issue against which the rule ran showing the Due date and Start date fields, we will be better able to help you diagnose the problem.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud