1 ACCEPTED SOLUTION
Hi @Arun61 ,
You can make use of duration field from sc_request table and calculate the fulfillment duration. But that field is from task table so you can either create own field for this and use calculated value as below :-
Field Type : Duration
(function calculatedFieldValue(current) {
// Add your code here
var startDate = current.closed_at.getDisplayValue();
var endDate = current.sys_created_on.getDisplayValue();
return gs.dateDiff( endDate, startDate,false); // return the calculated value
})(current);
Report :-
Hi @Arun61 ,
You can make use of duration field from sc_request table and calculate the fulfillment duration. But that field is from task table so you can either create own field for this and use calculated value as below :-
Field Type : Duration
(function calculatedFieldValue(current) {
// Add your code here
var startDate = current.closed_at.getDisplayValue();
var endDate = current.sys_created_on.getDisplayValue();
return gs.dateDiff( endDate, startDate,false); // return the calculated value
})(current);
Report :-
When i go to Dictionary - New, from table "Request[sc_request]", type "Duration", label and name it, i click on the calculated Value table i cannot change the calculated check box. any ideas?
