Auto populate Duration field

[Lucky1]

Hello all,

On the Change request, whenever the Actual End is populated by the system, then the difference between Actual Start and Actual End has to be auto populated in the Duration field (Which contains Days and Hours).

Note: Duration field backend name: (u_duration)

Can someone tell me how can I do this?

Regards,

Lucky

[J Siva]

Hi @Lucky1 
Try "Before Business rule" as belwo to calculate the duration.

(function executeRule(current, previous /*null when async*/ ) {
    var gdtStart = new GlideDateTime(current.getValue('work_start'));
    var gdtEnd = new GlideDateTime(current.getValue('work_end'));

    var duration = GlideDateTime.subtract(gdtStart, gdtEnd); //the difference between gdt1 and gdt2

    current.u_duration = duration.getDurationValue();

})(current, previous);

Output:

Regards,
Siva

[Ankur Bawiskar]

@Lucky1 

you can use before update business rule to populate the custom duration field

(function executeRule(current, previous) { // Add your code here
    var startDate = new GlideDateTime(current.start_date);
    var endDate = new GlideDateTime(current.end_date);
	current.u_duration = GlideDateTime.subtract(startDate, endDate);
})(current, previous);

OR

(function executeRule(current, previous) { // Add your code here
    var startDate = new GlideDateTime(current.start_date);
    var endDate = new GlideDateTime(current.end_date);
    var duration = endDate.getNumericValue() - startDate.getNumericValue();
    current.u_duration = new GlideDuration(duration);

})(current, previous);

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

[Lucky1]

Thank you Siva and Ankur,

Wil check and get back.

Regards,

Lucky

[Lucky1]

Hello Ankur and Siva,

Good day!!

I have tried both of your logics but it's not updating with correct value.

From the below pic, it has to be updated with 2 mins only.

I put the log message for duration, and it is showing

Can you please guide me?

Regards,

Lucky