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

Jira Automations - display difference between dates in hours and minutes

Małgorzata Adamska-Piotrowska

Hi
I have an automation that displays difference between two dates put in custom fields in Hours. I'm interested if it would be possible to have hours and minutes at the same time.

Smart value used is : {{[date1].diff([date2]).[unit]}}

Thanks

Gosia

Accepted answers

Marc -Devoteam-

Hi @Małgorzata Adamska-Piotrowska

If you would use:

{{[date1].diff([date2]).prettyPrint}}

So don't use an specified unit option, but the prettyPrint option

Kseniia Trushnikova

Hi @Małgorzata Adamska-Piotrowska,

Try to use just {{[date1].diff([date2])}}

It will return difference in hours and minutes.

All comments

Marc -Devoteam-

Hi @Małgorzata Adamska-Piotrowska

If you would use:

{{[date1].diff([date2]).prettyPrint}}

So don't use an specified unit option, but the prettyPrint option

Kseniia Trushnikova

Hi @Małgorzata Adamska-Piotrowska,

Try to use just {{[date1].diff([date2])}}

It will return difference in hours and minutes.

Małgorzata Adamska-Piotrowska

Hi. Thank for the suggestion. It doesn't work though.

My final action is set in Additional Fields section and after modification it looks like this.

{
"fields": {
"customfield_22188":
"{{issue.customfield_21712.diff(issue.customfield_21713).prettyPrint}}"
}
}

Should it be done in another way?

Małgorzata Adamska-Piotrowska

Hi- it doesn't work in my case.
I use advanced settings to edit my field but without any unit the automation does not work.
{
"fields": {
"customfield_22188":
"{{issue.customfield_21712.diff(issue.customfield_21713)}}"
}
}

Kseniia Trushnikova

@Małgorzata Adamska-Piotrowska, what is the type of customfield_22188?

Małgorzata Adamska-Piotrowska

It's a Number Field.

Marc -Devoteam-

Hi @Małgorzata Adamska-Piotrowska

I see in your reply to @Kseniia Trushnikova that customfield_22188 is a number field.

Then prettyPrin can't work as you store the result in a number field, that can only contain a number.

I think you should use a text field instead

Małgorzata Adamska-Piotrowska

Thanks. It worked without any unit but with prettyPrint option it doesn't.

Maybe there is also a trick somewhere else.

Sharmila Hiranandani_n7ngne

I have a similar problem. I want to update one custom filed (Cust_Response Duration) of type Short text, with the difference of current time and value in a custom date field. I am using the below smart value in my automation , but every time the rule runs , the Audit log shows "No Actions Performed" , Can anyone please help as to why the custom field "Cust_Response Durantion" is not getting updated .

Smart value which I have put in the automation rule for editing the custom field Cust_Response_Duration is :

Thanks

Sharmila

Sharmila Hiranandani_n7ngne

My issue is resolved now . Thanks

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-software

jira-software-cloud

automation