count due date change

avani2
Giga Contributor

we have two fields: due date and due date change.

due date change is a counter that will count the number of times the 'Due date' has been changed.

how to achieve this functionality.

1 ACCEPTED SOLUTION

rahulpandey
Kilo Sage

Hi Avani,



you can simply write a BR on update


current.due_date_change = current.due_date_change + 1;



and set "when to run" on due_date field changes.


View solution in original post

7 REPLIES 7

Hi Rahul,



this has bit issue.


when I am saving the record first time with due date empty.


and when I am updating the record with its first due date, due date changes to '1', which is not correct as it is the first time I am putting value in due date.



could you please suggest a solution


You can set in condition of script


previous.due_date !=''


Could also default the integer field to a value of -1