Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Automation: How to sum up differences of dates?

Karin.Gleichauf
Contributor
November 30, 2022

Hi there,

I calculate the difference of dates in an automation rule by {{fieldchange.from.toDate.diff(fieldchange.to.toDate)}} and write the result (e.g. "2 days") to a text field.

How can add it next time of the rules execution to the new result? Respectively how can I convert this result [text] to a number that I can sum up?

 

Best regards

Karin

1 answer

1 accepted

1 vote
Answer accepted
Karin.Gleichauf
Contributor
November 30, 2022

I could solve this by using {{fieldchange.from.toDate.diff(fieldchange.to.toDate).hours}} and then using a number field for the result..

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
atlassian, likes for trees, atlassian community, social impact, tree planting campaign, community kudos, atlassian giving, environmental impact, sustainability, likes for good, atlassian social responsibility, community challenge

Make every click count—help us plant 50,000 trees! 🌳

Want to make your everyday Community actions directly contribute to reforestation? The Atlassian Community can achieve this goal by liking a post, attending an ACE, sending your peers kudos, and so much more!

Help us plant more trees
AUG Leaders

Atlassian Community Events