This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
This is the problem i have. 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.
Textfield 1 : 13-06-2006 Textfield 2 : 16-06-2006 Duration = 3 days (How do i calculate this)
The problem is it does not work with this format. DD-MM-YYYY. Is it possible for me to use jsp and find out the difference between the days and save it to the mysql database. Thank you for your help.