Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Calculate two smart values containing dates

I am trying to create an automation for how long an issue was in progress. I have two dates now stored as a variable. How I can now show the difference without saving those dates. Alternatively, how I can store those values in the issue without making it visible to other users?

I tried: 

1. Jira smart values - date and time /



2. Jira smart values - math expressions



Any hint?

From log you can see, I am getting the correct date values.

Screenshot 2023-05-17 at 14.53.06.png

1 answer

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 17, 2023 • edited

Hi @Tomas Slavkovsky 

First thing: why do you want to hide this valuable piece of information?  Hiding it seems in opposition to the agile concept of transparency.  What problem are you trying to solve by hiding?

Regardless of that answer: mostly hiding the result is possible using visibility or obscurity.  For example, you could write the value to a comment with limited visibility (e.g., Admins only) or you could save the value to an Entity Property...which would be more difficult to see.


Next thing: how accurate do you need this value to be? 

  • If it needs to include all possible time in progress (e.g., issues move in/out of in-progress statuses multiple times) you will need to use the audit log.  That is theoretically possible with an automation rule, and it would be more complicated.
  • If your normal case is in-progress just one time, you only need one field for the result, as there is another field which can help statuscategorychangeddate, which is a text date/time, system field updated when an issue changes between categories of to-do, in-progress, and done.


Next...Depending upon the field types, you can use diff() as you found in the documentation.  You may need to convert with toDate if your dates are stored as text values.


Finally, the measure you are describing is typically called Age of WIP.  Please look at the post below for an example automation rule to calculate that value.  You can alter this rule to handle business days only, and to handle exceptions, as needed, or based on status transitions for finer granularity.

Kind regards,

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events