How to calculate date difference using jquery?

Reshma Bhalekar

8y14.1k

Hi,

I have one requirement and in that I want to calculate date difference using jQuery.

In this one date is modified date of ShaPoint lsit and second is todays date.

So I want difference between todays date and modified date.

I tried 2-3 ways but it is showing below errors

1) Invalid date format

2) NAN

Please help

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Md Tahmidul Abedin8y ago
Accepted answer
Hi Rashmi,
As the process you are trying to formate the date, it is converting the date into string formate. I think the bellow example will do your requirments.
var start = new Date("2010-04-01"),
    end   = new Date(),
    diff  = new Date(end - start),
    days  = diff/1000/60/60/24;

days; //=> 8.525845775462964
Hope it will help.
+6
Reshma Bhalekar8y ago
Hi Md. Tahmidul Abedin,

This works for me.. Thanks a lot.
+2
Piyush Agarwal8y ago
Jquery is preety powerful to find date difference in Sharepoint.
We can even exclude weekends by writing a small piece of code to find number of days with in two specified dates.

Please share your jquery code so that we can debug.
0
Reshma Bhalekar8y ago
HI,

This is my code,

for (var j = 0; j < data1.d.results.length; j++)
{
   var birthdate = new Date(data1.d.results[j].Modified);

      alert(new Date(Date.parse(birthdate)).format("MM/dd/yyyy")); //Output = 02/19/2018
      alert(moment().format("MM/DD/YYYY")); //Output = 02/22/2018

   // here I wants to calculate todays date - modified date
   but it is showing Invalid date and if we direct do substraction it is showing NaN

}
Please help.
+1
Nanddeep Nachan8y ago
Here are few solutions
https://stackoverflow.com/questions/2609513/jquery-calculate-day-difference-in-2-date-textboxes
https://forums.asp.net/t/2027276.aspx?how+to+calculate+number+of+days+between+two+dates+using+jquery
+2
Reshma Bhalekar8y ago
Hi Ramesh,

I tried using moment.js but I am getting modified date from SharePoint list in below format
Mon Feb 19 2018 11:59:35 GMT+0530 and I am not able to convert it in "YYYY-DD-MM" format
+1
Ramesh Palanivel8y ago
Hi Rasmi,

I recommend to you to use Moment.Js file. It has more predefined function to compare and validate date.
+2