Difference between 2 dates in days in catalog client script

[soumyadaggula]

Hi team , 

I am trying to get the difference of 2 dates in days , I tried below script , but its not working :

Catalog Client Scripts

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

var ga=new GlideAjax('NofDays');

ga.addParam('sysparm_name','days');

ga.addParam('sysparm_start',g_form.getValue('u_date'));

ga.addParam('sysparm_end',g_form.getValue('audit_last_test'));

ga.getXMLWait();

answer=ga.getAnswer();

g_form.setValue('audit_required_timeframe',answer);
}

Script Include :

var NofDays = Class.create();

NofDays.prototype = Object.extendsObject(AbstractAjaxProcessor, {

days:function(){

var start=this.getParameter('sysparm_start');

var end=this.getParameter('sysparm_end');

return gs.dateDiff(start,end);

},

type: 'NofDays'

});

[AMan1997]

Hi @soumyadaggula ,

You can split the response to obtain just the number part. See below:

---

---

var days = comments.split(" ")[0];​

[Mohith Devatte · Accepted solution]

Hello @soumyadaggula ,

can  you try this in script include ?

var NofDays = Class.create();


NofDays.prototype = Object.extendsObject(AbstractAjaxProcessor, {


days:function(){




var start = new GlideDateTime(this.getParameter('sysparm_start'));
  var end = new GlideDateTime(this.getParameter('sysparm_end'));
  var diff = GlideDateTime.subtract(start, end);
  var days = diff.getRoundedDayPart();
return days;

 

},


type: 'NofDays'


});

Hope this helps 

Mark my answer correct if this helps you 

Thanks

[soumyadaggula]

thank you So much Mohit , this is working now as expected , thanks a Ton !!

[AMan1997]

Check out this existing solution:

Calculate Number of Days between two dates(Start and End Date)https://www.servicenow.com/community/developer-forum/calculate-number-of-days-between-two-dates-star...