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.
Thanks Mohanraj.
Good practice to show us the usage of value change smart value and the date function. 👍🏻
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
Thanks for pointing out @Yoann LEGRAND
It looks like you're new here. Sign in or register to get started.