How to add 1 more day to a particular field populating a days count?

akshay parekar1
Tera Contributor

Hello everyone,

i have achieved my requirement partially, help me to achieve it completely

on my form, there are two date fields and after selecting them , i'm getting difference between that dates in days in another field .

Now, each and every time after selecting those dates , i want difference between them added by 1 more day automatically in that populating field

How to do this?please help me out

 

my script include:

 

var DaysCalculations = Class.create();

DaysCalculations.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {

    getDiffrence: function() {

        var datediff;

        var date1 = new GlideDate();
        var date2 = new GlideDate();

        var fromDate = this.getParameter('sysparm_from_date');
        var toDate = this.getParameter('sysparm_to_date');

        date1.setValue(fromDate);
        date2.setValue(toDate);

        datediff = GlideDate.subtract(date1, date2);

        return datediff.getDisplayValue();
    },

    type: 'DaysCalculations'


});

 

my client script:

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '') {
        return;
    }
    var fromDate = g_form.getValue('leave_start_date');
    var toDate = g_form.getValue('leave_end_date');
    var ga = new GlideAjax('DaysCalculations');
    ga.addParam('sysparm_name', 'getDiffrence');
    ga.addParam('sysparm_from_date', fromDate);
    ga.addParam('sysparm_to_date', toDate);

    ga.getXML(HelloWorldParse);

    function HelloWorldParse(response) {

        var answer = response.responseXML.documentElement.getAttribute("answer");

        var b = g_form.setValue('requesting_leaves', answer);


    }


}

2 REPLIES 2

Aman Kumar S
Kilo Patron

Have you started with something in the script include?

Is your field date or datetime?

You can follow below article:

Calculate Number of Days between two dates(Start and End Date)

 

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂

Best Regards
Aman Kumar

@akshay parekar ,

Also have a look at below article:

How to calculate difference between two dates in hours ?

 

Best Regards
Aman Kumar