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 the difference between two custom fields

Dave Jones_2nfsqj

I am attempting to calculate the difference between two custom fields (in days) and populate the result into a number field.

See screenshot below for what I have entered.

I get an error message which states "Additional fields contains invalid field(s) in 'update' or 'fields' section: Custom Field Name" but this does not tell me at all where the issue is. I have tried various variations but get no where.

Jira error.png

Thanks for your help.

Accepted answers

Alex Koxaras -Relational-

Hi @Dave Jones and welcome to the community,

Are these two custom field date fields? From the looks of it, the second field, to which you have append the suffix .value, isn't a date field. So I'm not sure you can calculate the difference in days.

Ste Wright

Hi @Dave Jones

I recreated this, using the Start Date and End Date fields, and using this smart value:

{{issue.customfield_10123.diff(issue.customfield_10456).days}}

^ And it worked as expected.

What does the rest of your rule look like? Are these both Date Picker fields?

Ste

All comments

Alex Koxaras -Relational-

Hi @Dave Jones and welcome to the community,

Ste Wright

Hi @Dave Jones

I recreated this, using the Start Date and End Date fields, and using this smart value:

{{issue.customfield_10123.diff(issue.customfield_10456).days}}

^ And it worked as expected.

What does the rest of your rule look like? Are these both Date Picker fields?

Ste

Dave Jones_2nfsqj

Thank you for your quick response. I have tried the same as you entered but it still does not work for me:

Jira error.png

Below are the screenshots of the custom fields so you can see their IDs:

Date Root Cause Populated.png Date Assigned to AEMO.png

Here is the rest of the rule, but there does not seem to be anything unusual? I should explain I am very new to this so I am probably missing something basic.

Automation Rule.png

Dave Jones_2nfsqj

Hello Alex. I have posted screenshots of both custom fields above. They are both Date fields. I have tried without the value suffix and it still does not work.

Alex Koxaras -Relational-

@Dave Jones close the additional fields (JSON) which you have opened ("more options").

Dave Jones_2nfsqj

Thank you. That was it.

Welcome!

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

Quick Links

Find more posts tagged with

jira-service-desk

jira-service-management