Calculate duration

[siva118]

Create a duration field (field type: duration) on the item order table and calculate the duration between the creation time and the present time of the record

[-O-]

Is this a random thought? A question? Something else?

[dgarad · Accepted solution]

Hi @siva118 

 Create Script Include 

var AjaxDurCalcToday = Class.create();


AjaxDurCalcToday.prototype = Object.extendsObject(AbstractAjaxProcessor, {


       durCalcToday: function() {


               return gs.dateDiff(this.getParameter('sysparm_strt'),new GlideDateTime().getDisplayValue(), false);


       }


});

And the onLoad client script 

function onLoad() {


       var strt = g_form.getValue('sys_created_on'); 


       var ajax = new GlideAjax('AjaxDurCalcToday'); 


       ajax.addParam('sysparm_name','durCalcToday'); 


       ajax.addParam('sysparm_strt',strt); 


       ajax.getXMLWait(); 


       var answer = ajax.getAnswer(); 


       g_form.setValue('u_total_time_open', answer); 


}

[siva118]

It's working Awesome 

Thank you

Sivanjaneyulu Bellamkonda