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

Calculating using 2 custom fields (date time)

unknown

Hi,

Due to some backlogs, there is a need for us to input incident start time and end time for the previous incidents. I have created 2 custom fields for this.

Im thinking about adding another custom field (incident duration) and the computation of 2 custom fields (start and end time) would be calculated and appear on that duration field.

Is there a way to do this without installing an app/plugin? I have done the following:

1. Through SLA - cannot choose the custom field to calculate

2. Automation - do not seem to have add calculation / computation on the Action component

Appreciate your help.

Accepted answers

Peter Youngman

Hi @[deleted]

You can use "smart values" to make a calculation and update a field value with it.

Use the "Edit issue" action to set your "duration" custom field to something like this:

The above calculates number of business days between a date in customfield_13455 and "now" (today).

You would need to change "now" in the above to your second customfield (and the first to point to the correct customfield). e.g.

All comments

Peter Youngman

Hi @[deleted]

You can use "smart values" to make a calculation and update a field value with it.

Use the "Edit issue" action to set your "duration" custom field to something like this:

The above calculates number of business days between a date in customfield_13455 and "now" (today).

You would need to change "now" in the above to your second customfield (and the first to point to the correct customfield). e.g.

unknown

thank you, worked for me.

unknown

hi @Peter Youngman I did make it work, however there is one issue. I changed my custom field from date time picker to number field so it would just give whole numbers instead of date time.

The automation rule is successful, but the number field shows 0. Is there a need for me to edit anything?

Eswar Prasad_hymx1p

@Peter Youngman - When I write below value its giving difference in days:

What value should be written to get difference in 'days, months, years' between two Date fields?

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-service-management-cloud

jira-service-management