Automation: How to sum up differences of dates?

[Karin_Gleichauf]

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

[Karin_Gleichauf · Accepted solution]

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