Automation: Date difference {{[date1].diff([date2]).[unit]}}

[emma.deantonio]

Hello, 

We are trying to use the automation stated above but it is not working. Can someone help us? We are doing the following:

We want to calculate the days a task goes through the column "Validación". When the card goes through "Valildación", these two date fields are filled automatically.

 

So, in order to calculate the days between these two dates we created a rule:

In the second "Then" field, we used the following formula: {{issue.Fecha Fin Validación.diff(issue.Fecha Inicio Validación).abs.days}}

For some reason, this is not working, but we don't understand why. Could someone please help us?

If you need more information, do not hesitate to tell me.

Thank you very much in advance!!! :) 

[Manne Kjærby - ProProces · Accepted solution]

Hi Emma.

Have you tried switching abs and days positions so it looks like this:

{{issue.Fecha Fin Validación.diff(issue.Fecha Inicio Validación).days.abs}}

[emma.deantonio]

I'll try it, thank you very much!!