Hi @Alon Grod
Your script has the right idea, but there are a few issues that need to be addressed. The `GlideDateTime.subtract()` method returns a `GlideDuration` object, which represents the difference between two `GlideDateTime` objects. However, `GlideDateTime.add()` is not a valid method for adding durations. Instead, you should use the `add()` method on a `GlideDuration` object to add another duration to it.
Here's a corrected version of your script:
(function executeRule(current, previous /*null when async*/) {
// Create GlideDateTime objects for the two Date/Time fields
var updatedOn = new GlideDateTime(current.sys_updated_on);
var dateMoveToPending = new GlideDateTime(current.u_date_move_to_pending);
// Calculate the duration between the two Date/Time fields
var duration = GlideDateTime.subtract(updatedOn, dateMoveToPending);
// If current.u_pending_time is not empty, create a GlideDuration object from it
var currentPendingTime;
if (current.u_pending_time != '') {
currentPendingTime = new GlideDuration(current.u_pending_time);
} else {
// If it's empty, initialize a new GlideDuration with zero duration
currentPendingTime = new GlideDuration(0);
}
// Add the new duration to the current pending time
currentPendingTime.add(duration);
// Set the new total duration back to the 'u_pending_time' field
current.setValue('u_pending_time', currentPendingTime.getDisplayValue());
// Update the record
current.update();
})(current, previous);
Please note the following changes:
1. I've added a check to see if `current.u_pending_time` is not empty before creating a `GlideDuration` object from it. If it's empty, we initialize a new `GlideDuration` with zero duration.
2. I've used the `add()` method on the `GlideDuration` object to add the new duration to the current pending time.
3. I've used `getDisplayValue()` to get the display value of the `GlideDuration` object, which is suitable for setting the value of the duration field.
4. I've added a call to `current.update()` to save the changes to the record. This may or may not be necessary depending on the context in which this script is running. If this script is part of a business rule that runs on 'before' events, you should remove the `current.update()` line to prevent a recursive update.
Please mark this response as correct or helpful if it assisted you with your question.
