Any advice on using duration field for closed problem tasks

[JohnEJasinski]

Help - trying to use the Duration field on Closed Problem Tasks.   

Created to Closed, but nothing is showing in the Duration field.   

What am I missing?  

[Dr Atul G- LNG]

Hi @JohnEJasinski 

Duration is a field whcih is on the task table and here are a few details

https://www.servicenow.com/community/itsm-forum/how-to-calculate-duration-field-on-task-table/m-p/65...

https://www.servicenow.com/community/csm-forum/catalog-task-duration-business-rule/m-p/403227

https://www.servicenow.com/community/developer-forum/how-to-setup-duration-field-on-sc-task/m-p/2613...

[Robert H]

Hello @JohnEJasinski ,

Using the Duration and especially the Business Duration fields is no longer recommended, as SLAs provide a better alternative that gives more control over the schedules and time zones involved in the calculation.

If you want to go ahead with using the duration fields you can create a Business Rule as shown below:

Advanced Script:

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

    current.business_duration = gs.calDateDiff(current.opened_at.getDisplayValue(), current.closed_at.getDisplayValue(), false);
	
    current.calendar_duration = gs.dateDiff(current.opened_at.getDisplayValue(), current.closed_at.getDisplayValue(), false);

})(current, previous);

Regards,

Robert