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 Age via automations

Martin_ukbd1r

Good day!

I want an automation to write the amount of days since the creation of the issue and today.

I am using Jira Product Discovery. technically I will run the automation once a day and update the age field.

I know now how to add days to a date, but I don't know how I could calculate the difference between.

I believe I need to use the {{createdIssue.created}} and now.jiraDate parameters.

Any idea?

I cannot use a marketplace app to do so.

Accepted answers

Duc Thang TRAN

Hello @Martin

I don't use Produc Discovery but in Jira Software, i using this smart value :{{issue.created.diff(now).days}}

Hope this can be use on JPD

All comments

Duc Thang TRAN

Hello @Martin

I don't use Produc Discovery but in Jira Software, i using this smart value :{{issue.created.diff(now).days}}

Hope this can be use on JPD

Rudy Holtkamp

Hi @Martin ,

I'm prettyr sure you can't use the formula in the JPD field. But you can create a field called 'Age' and update this once a day via automatoin like @Duc Thang TRAN said.

I would recommend to only do this for issues that have not been resolved, so set a JQL on the scheduled trigger.

Cheers,

Rudy

Martin_ukbd1r

Hi guy,

this is a good trail. I ran it but the numbers were negatives, but accurate. I tweeked it to this:

{
"fields": {
"customfield_10842": "{{#=}}{{now.diff(issue.created).days}} * -1{{/}}"
}
}

Thank you all!

Duc Thang TRAN

@Martin
That's why I reversed the fields {{issue.created.diff(now).days}} to get a positive number of days. But your way works as well, and I'm glad it helped you.

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

jiraproductdiscovery