addDaysUTC() is not counting current day

[Hari1]

Hi,

I have a requirement to count days excluding weekends. I have a date range for an example.

12/Jan/2022 - 25/Jan/2022, returns 9 days where as it return 10 days.

Below is the code that i am using

Client Script:

var fromDate = g_form.getValue("from_date");
var toDate = g_form.getValue("to_date");

var ajax = new GlideAjax('CalDiffDateIteration');
        ajax.addParam('sysparm_name', 'durCalc');
        ajax.addParam('sysparm_fromDate', fromDate);
        ajax.addParam('sysparm_toDate', toDate);
        ajax.getXML(returnIterationDays);

        function returnIterationDays(response) {
            var answer = response.responseXML.documentElement.getAttribute("answer");
            answer = parseInt(answer);
	    
            g_form.setValue(setItrNum, answer);
        }

Script Include:

var CalDiffDateIteration = Class.create();
CalDiffDateIteration.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {
    durCalc: function() {
		
		var fromDate = new GlideDateTime(this.getParameter('sysparm_fromDate'));
        var toDate = new GlideDateTime(this.getParameter('sysparm_toDate'));

       

        var days = getDateDiffExcWeekends(fromDate, toDate);
		
		return days;
		
        function getDateDiffExcWeekends(start, end) {
			
			gs.info("Script - start:" + start);
			gs.info("Script - end:" + end);
			
            var days = 0;
            while (start < end) {
                start.addDaysUTC(1);

                if (start.getDayOfWeekUTC() != 6 && start.getDayOfWeekUTC() != 7) {
                    days++;
                }
            }
			
			gs.info("Script - days:" + days);
            return days;
        }
    }
});

[Community Alums]

Hi Hari,

Just return days+1 in your script. It will work fine.

Thanks,

Visakha