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

URGENT! Calculate the difference between two dates.

Dionei Piazza

Hello,

I want to calculate the difference between two dates.

I created two custom fields. A DateTime Picker to store the pull request time (called "Pull request opening date"). And another "Total pull request time" field of type Number to store the difference.

In my automation I'm doing the calculation as follows:

{{now.diff (Pull request opening date.value) .minutes}}

Is not working. Automation is performed with success, but does not generate any results. The result field is "empty". I figured the reason was that there was no a completed hour difference between dates, just minutes. So I switched to "minutes", but it still doesn't work.

Filtering the issue in Jira, the value of the data field is 03/Sep/20 2:35 PM.

Someone to help me?

Accepted answers

All comments

John Funk

Hi @Dionei Piazza - Try putting issue. in front of the field:

{{now.diff(issue.Pull request opening date.value).minutes}}

Bill Sheboy

Hi,

As this is already a date/time field, you may not need the .value part. I didn't need it when I use custom fields of that type with smart value functions.

Best regards,

Bill

Dionei Piazza

Hi @John Funk

I tried, but it still doesn't work.

Empty field.

Dionei Piazza

Hey @Bill Sheboy

I follow de Atlassian Jira documentation of smart values.

If I understood what you said, would the automation script be like this:

{{now.diff(issue.Pull request opening date).minutes}} ??

Manrique Soto_wzfxif

Do this works for timestamp instead of dates?

I have a Timestamp called "WIN Timestamp" saving 'now' when the WIP started and WIP Time to calculate the diff from WIP Timestamp and now. I use the formula below {{issue.WIP Timestamp.diff(now).minutes}} but as a resolve I got Dec 31 ,2001. Not sure what I'm missing.

Bill Sheboy

Hi @Manrique Soto

For something like this, please consider creating a new question or staying on the original thread.

The answer to your question is: yes. The earlier examples all use date/time fields. Here is an example I use to measure Lead Time in fractional days.

{{#=}}ROUND({{issue.Created.diff(issue.Resolved).millis}} / (1000*60*60*24), 3){{/}}

Please consider logging your WIP Timestamp field, as it may not be set to a date/time value or could be null.

Best regards,

Bill

beacon.grayson

I am trying this very same thing trying to update a number field "Days" with the number of days that have passed since the issue Start Date. While the automation runs to success and says the issues were edited, the number field "Days" remains empty.

I cannot figure out why this does not do anything. I've reviewed the documentation and am stumped

beacon.grayson

Minor correction - If there is a value in the Day field already, the automation is setting it to null. So this calculated value is returning null. I don't get it.

John Funk

Hi @beacon.grayson - It is better if you create a new question in the Community. That way more people will see it and respond, and specific details to your situation can be discussed. Please post your full rule with the new question, especially showing the details of the field update in the Edit Issue component.

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

atl-gruland

automation

smart-value

atl-fozzie