How to calculate date from two fields

[vanan saravanan]

Hi, i have two textfields. Start date and end date. I use a date picker to enter the value into the textfields. The values are then stored into a mysql database. This part works fine. I got 3 fields in my database. A startdate, enddate and duration. My question is how do i find out the duration if i have two dates in two textfields.

Example

Textfield 1 : 13-06-2006
Textfield 2 : 16-06-2006
Duration = 3 days (How do i calculate this)

[Eric Pascarello]

Look into the Date() object in JavaScript. Plenty tutorials online with a simple search on Google.

Eric

[vanan saravanan]

I tried this but it does not seem to work. "demoform" is my form name and "dc1" and "dc2" is the textfield name.


<script type="text/javascript">
<!--
function checkdate() {
var begDate = new Date(document.demoform.dc1.value);
var endDate = new Date(document.demoform.dc2.value);
var difDate = endDate.getTime() - begDate.getTime();
var days = difDate / (24*60*60*1000);
alert(days);
}
//-->
</script>

[Eric Pascarello]

var difDate = endDate - begDate;


Eric

[vanan saravanan]

I'm using DD-MM-YYYY format and the script does not seem to work. It only works if i use MM/DD/YY.

How do i change it.

Thank you for your help.

[vanan saravanan]

Anyone able to help me with the above problem.

[vanan saravanan]

Is there any other way to solve the problem of finding out the difference between days. I need to use DD-MM-YYYY as thats how the dates are saved in the database.

Database is mysql
Code is jsp

[Eric Pascarello]

People do have lives away from the Ranch so you do not need to ask all the time. You have to change the format of the data. A simple split will do the job.

var d1 = document.forms[0].elementName.valuesplit("-");
var date1 = new Date(d1[2],parseInt(d1[1])-1,d1[0]);

Eric

[vanan saravanan]

Problem solved. Thank you.