Automation to calculate the difference between old and new Due date

[#1]

Hello All, recently came across a scenario where user want to calculate the difference of days between old and new due date when due date field is changed. The following automation rule will help achieve this requirement.

[YY Brother]

Thanks Mohanraj. 

Good practice to show us the usage of value change smart value and the date function. 👍🏻

[Yoann LEGRAND]

Hi @Mohanraj Thangamuthu , 

Thanks for sharing, I actually got this exact question from two of my clients recently.

However, I think your calculation is reversed :

{{currentDuedate.toDate.diff(previousDuedate.toDate).days}}

Should be :

{{previousDuedate.toDate.diff(currentDuedate.toDate).days}}

Otherwise, the result will be negative :)
For example, if the date changes from 05/23 to 05/29, it will show -6 instead of 6 days.

Have a nice day ;)

[Mohanraj Thangamuthu]

Thanks for pointing out @Yoann LEGRAND