How to create a field that calculates the age of an idea

[Alfred Tsang]

I want to create a numeric field, which has the age of the idea in days, calculated from the created date to today

[Jack Brickey · Accepted solution]

Hi @Alfred Tsang , welcome to the Community.

you can create a custom field (number) and use the following to calculate age and update the field.

 {{issue.created.diff(now).days}}

The rule would look like this....

• Trigger - scheduled daily
• Conditions - based on your needs to update the desired issues
• Action - edit issue and set your custom field using the above smart value.

An alternative is to simply use a smart value to increment the number in the field. Check the docs for syntax if desired.

[Jens Schumacher - Released_so]

It's worth noting that @Jack Brickey's suggestion refers to using Jira Automation to periodically update the field.

[Alfred Tsang]

That's done it, thanks!

Support gave me the same resolution with the added detail of using a JQL to filter the ideas first.

[William]

That’s such a clever concept — calculating the age of an idea sounds really useful for tracking progress! I’d probably test the logic with Besterekenmachine first to make sure the formula gives accurate results.