calculating difference of dates

[prashantkuppa]

hi,

iam struggling with difference between two dates of format type dd/mm/yyyy

i need difference between two dates olddate(dd/mm/yyyy) - newdate(dd/mm/yyyy) and this should be in java script please helpme


thanking you

[ak1dnar]

If you need it from JAVASCRIPT ask the question in this forum

Moving from Php forum.

[phvfl]

Hi,

The function that you would be looking to use would be the setFullYear() function of the Date object in javascript. setFullYear() sets the date value, taking three variables (four digit year, month and day). The month is base 0 so Janary would be 0, for example:

var date1 = new Date();
date1.setFullYear(2007,0,1);
 

would set date1 to the 1st January 2007. The dates are actually stored as integers and their base value is the number of milliseconds since 1st January 1970, so if you subtract one date from another you would get the difference in time in milliseconds. Once you have this it would be simple arithmetics to convert the difference into whatever unit of time that you want.

If you are still having difficulties please post back your attempted code to look at.

[mrhoo]

function daysbetween(s1,s2){
    /*
    First, convert your strings to javascript Date objects.
    Reverse the order from dd/mm/yyyy to yyyy/mm/dd,
     and subtract 1 from the month field
     (months are 0-based, january is 0)
    */
 
    var d1= s1.split(/\W+/).reverse();
    var d2= s2.split(/\W+/).reverse();
 
    d1= new Date(d1[0],d1[1]-1,d1[2]);
    d2= new Date(d2[0],d2[1]-1,d2[2]);
 
    //Now you can subtract the two dates and return the difference in days
 
    return Math.floor((d2-d1)/8.64e7)+ ' d
}
// Test Case
 
var s1= '06/09/2007';
var s2= '25/12/2007';
alert(daysbetween(s1,s2))