I want to create a numeric field, which has the age of the idea in days, calculated from the created date to today
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....
An alternative is to simply use a smart value to increment the number in the field. Check the docs for syntax if desired.
It's worth noting that @Jack Brickey's suggestion refers to using Jira Automation to periodically update the field.
That's done it, thanks!
Support gave me the same resolution with the added detail of using a JQL to filter the ideas first.
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.
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.
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.
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.
This is a really useful approach, especially when you want to keep track of how long an idea has been around and understand whether it is still relevant or worth developing. Using a calculated field based on the idea’s creation date makes the process simple and keeps the information updated automatically.
I also like how this concept can be extended to other practical calculations where you need quick results without doing everything manually. For example, an ippt calculator can be useful for getting instant calculations in a similar way. The key is to keep the formula simple and make the field update automatically whenever the underlying date or value changes.
It looks like you're new here. Sign in or register to get started.
