Not able to update date time in column

[Akshaykhare]

I want to add one column which will show the date and time at which the status of request is change to Completed. I have created the column and created business rule to update the column with the date and time but somehow the script is not working. Please suggest any improvements

(function executeRule(current, previous /*null when async*/) {

    // Add your code here

    if(current.u_request_state == '6'){

    current.u_completed = gs.nowDateTime();

    }

})(current, previous);

[Ankur Bawiskar · Accepted solution]

@Akshaykhare 

you can use before update BR with correct condition

Script is this

current.setValue('u_completed', new GlideDateTime());

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Runjay Patel · Accepted solution]

Hi @Akshaykhare ,

You dont require to write script for this, just configure the business rule like below.

In when to run select state changes to completed.

And in action section select the date same as updated.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------