getting time and date from datetime field in javascript

Question

Hello guys, I need to get hours from the difference between two datetime fields. I wrote the javascript which will get the date from datetime field.

But its not getting the correct time that entered on date time field. Its defaultly getting the current time on my system.

So do you guys have any idea. How to get time from date time fields. and how calculate hours between two datetime fields using javascript.

Answer 1

You can do this with calculated columns.

http://office.microsoft.com/en-gb/windows-sharepoint-services-help/examples-of-common-formulas-HA001160947.aspx

I have found this with Jquery:

http://www.endusersharepoint.com/2009/01/06/jquery-for-everyone-total-of-time-differences/

Serge

 

---

Serge

Answer 2

Please go through this Calculate difference between two dates (in hours)

Or

Try this if you only want difference between dates without time field

<script type="text/javascript">

	startDateValue = "10/5/2006" ; // 10 May 2006
    endDateValue ="11/5/2006"; // 11 May 2006

	var vStart = startDateValue.split("/");   
	var vEnd = endDateValue.split("/");
	
	var startDate = new Date(vStart[2],(vStart[1]-1),vStart[0]); //date format(Fullyear,month,date) 
	var endDate = new Date(vEnd[2],(vEnd[1]-1),vEnd[0]); 

    var difference = endDate.getTime() - startDate.getTime();
 
    var daysDifference = Math.floor(difference/1000/60/60/24);
   
	var hoursDifference = Math.floor(difference/1000/60/60);
   
    var minutesDifference = Math.floor(difference/1000/60);
   
    var secondsDifference = Math.floor(difference/1000);
 
	alert('\n Day diff: ' + daysDifference + '\n Hours diff: ' + hoursDifference + '\n Minute Diff: ' + minutesDifference + '\n Second Diff: ' + secondsDifference);

</script>

 

---

Regards, Sandip Patil, .Net,Sharepoint Developer www.worldofsharepoint.com