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.

[Anurag Tripathi]

Is this a Before BR?

[Anurag Tripathi]

Use this in a Before BR

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

    // Add your code here
    if(current.u_request_state == '6'){
    current.u_completed =  new GlideDateTime();
    }

[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.

[Community Alums]

@Akshaykhare 

a Business rule should run on the "After" update to capture changes to the status field after it's saved.

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

// Check if the status has changed to "6"

if (current.status == '6' && previous.status != '6') {

// Set the custom date/time field with the current date and time

current.u_completed = new GlideDateTime();

}

})(current, previous);