Date Time Calculation

[littlelingling0]

Dear Sir,

I had create two fields in incident, one is 'assign date', another is 'resolved date'.

How can I calculate the date difference between 'assign date' and 'resolved date' by using client script? Then put the result into 'date diff' field.

Thanks.

Best regards,

Ling

[bubuprasadswain]

Hi,

http://wiki.servicenow.com/index.php?title=GlideSystem_Date_and_Time_Functions#calDateDiff.28String....

Please check this link.

[Julian Hoch]

There's two ways to perform date difference calculation on the client that I found the easiest.

One is to use the "getDateDiff" method of the "AjaxProjectTaskUtil" Script Include via Ajax, or to use getDateFromFormat(date, g_user_date_format) to convert the date to a format you can make calculations on the client.

[drbz · Accepted solution]

Hello,

you can use this example from wiki:

http://wiki.servicenow.com/index.php?title=Setting_the_Duration_Field_Value#Calculating_a_duration_a...

Example usage (incident form):

Client script:

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
     if (isLoading || newValue === '') {
           return;
     }

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

   var ajax = new GlideAjax('AjaxDurCalc');
     ajax.addParam('sysparm_name','durCalc');
     ajax.addParam('sysparm_strt',strt);
     ajax.addParam('sysparm_end',end);
     ajax.getXMLWait();

   var answer = ajax.getAnswer();

   g_form.addInfoMessage(answer);
   g_form.setValue('u_dur', answer);

}

Script include (client callable):

var AjaxDurCalc = Class.create();
AjaxDurCalc.prototype = Object.extendsObject(AbstractAjaxProcessor, {
 durCalc: function() {
     return gs.dateDiff(this.getParameter('sysparm_strt'),this.getParameter('sysparm_end'), false);
   }
});

[littlelingling0]

May I know how can I deduct the time which is non office hours? Just like the calculation for business duration..

thanks.