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.

[Anas Sajid]

The Jira Automation approach makes sense here, especially if the goal is to keep the “Idea Age” field updated automatically.

One thing I would recommend when setting this up is testing the date calculation with a few different scenarios first. Date differences can become confusing when you're checking an idea created months or years ago, comparing exact dates, or trying to verify whether the result is actually counting the elapsed days you expect.

For a quick manual check, an online age/date calculator can also be useful alongside the Jira automation. You can enter the original date and compare the calculated number of days with the value produced by the Jira smart value. That makes it easier to catch configuration or date-calculation mistakes before relying on the field for reporting.

Once the calculation is confirmed, the scheduled automation is a much better solution because the field can stay updated without manually recalculating the age of every idea.

[bratgenerator]

You can create an “Idea Age” field by calculating the difference between the idea’s creation date and the current date. This helps track how long an idea has been active and improves project management efficiency.

Similarly, online tools like CGPA To percentage to convert 6.5 sgpa in percentage  simplify calculations by instantly converting academic grades into percentages accurately.

[Resarchzone]

Creating a field to calculate the age of an idea is a smart way to track progress and see which concepts need attention. https://ti84calculat.com/  Using a tool like   makes it easy to double-check the calculations and keep your workflow accurate and stress-free.

[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.