Hi Community,
I'm trying calculate the duration between two dates, but separate them out by Year, Month, and Date. For example, if Start Date = Jan 1, 2016 and End Date = July 4, 2017, I want my Year field to show 1 year, my Month field to show 7 months, and my Day field to show 4 days. Here's what my form looks like:
I've seen other posts about duration and can't seem to get it to work in our scoped application. Here's what I've done with the script include:
Name: counttime
Client callable: true
Accessible from: All Application Scopes
var counttime = Class.create();
counttime.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {
calcutime: function() {
var start= this.getParameter('sysparm_strt');
var end = this.getParameter('sysparm_end');
var answer = gs.dateDiff(start, end, true);
answer = answer/(60*60*24*365);
return answer;
},
type: 'counttime'
});
And my client script on my table looks like this:
Name: Duration
Type: onChange
Field: Year
function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue === '') {
return;
}
var strt = g_form.getValue('from');
var end = g_form.getValue('to');
var ajax = new GlideAjax('counttime');
ajax.addParam('sysparm_name','calcutime');
ajax.addParam('sysparm_strt',strt);
ajax.addParam('sysparm_end',end);
ajax.getXMLWait();
g_form.setValue('year', answer);
}
When I enter in my From and To dates, no numbers appear in my Year field. Any advice on how to fix this?
