Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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