Monday 22 June 2020

Calculate Day Difference in 2 dates using jquery

/////////////// html

var days = DateDiff_BetweenTowDates("23/03/2020" "24/05/2020", "dd/mm/yyyy");

              or

var days = DateDiff_BetweenTowDates("2020/03/23" "2020/05/23""yyyy/mm/dd");

              or

var days = DateDiff_BetweenTowDates("03/23/2020" "05/25/2020""mm/dd/yyyy");

////////////// js


function DateDiff_BetweenTowDates(dateFrm, DateTo, CurrentFormat) {
    var start, end;
    if (CurrentFormat.toLowerCase().substring(0, 2) == "dd") {
        var d1 = dateFrm.split('/');
        var d2 = DateTo.split('/');
        start = d1[1] + '/' + d1[0] + '/' + d1[2];
        end = d2[1] + '/' + d2[0] + '/' + d2[2];
    }
    else if (CurrentFormat.toLowerCase().substring(0, 2) == "mm") {
        start = dateFrm;
        end = DateTo;
    }
    else if (CurrentFormat.toLowerCase().substring(0, 2) == "yy") {
        var d1 = dateFrm.split('/');
        var d2 = DateTo.split('/');
        start = d1[1] + '/' + d1[0] + '/' + d1[2];
        end = d2[1] + '/' + d2[0] + '/' + d2[2];
    }
    else {
        return false;
    }
    var dt1 = new Date(start);
    var dt2 = new Date(end);
    return days = (dt2 - dt1) / (1000 * 60 * 60 * 24);
}

No comments:

Post a Comment

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...