Thread: function timeDiff

Hi forum

I hope you can help me with a problem on a function which should work properly but isn’t.

The function is:

function timeDiff(time1, time2) {

if(isNaN(Date.parse(time1)) || isNaN(Date.parse(time2))) return '';

return ( ((Date.parse(time2) -Date.parse(time1))/1000)/60 )
}

The problem is that if I set time1 to say 25/05/11 and time2 to say 26/05/2011 the result should be 1440 (the number of minutes in I day) however the result I am receiving is 44640 (the number of minutes in 31 days)

I have check the date formats on the server and the dbase and they are all set to the UK format of dd/mm/yyyy

My data connection is SQL

Any ideas ?

Thanks

bobby

Hi copeg

Thanks for the prompt reply, I am new to java and its workings so please can you give more details as i have no idea what you mean by SSCCE and java.util.Data and java.sql.Date

I am trying to do a calculation between to date fields in a data table the data connection is SQL and all my date formats in the table are set to the UK format of dd/mm/yyyy.

Thanks
Bobby

Hi again copeg

Is there a standard function I can use and call which calculates / returns the days between to dates which is what I am trying to do.

Thanks Again

Bobby

Hi again copeg

I will read up on your suggested material

Thanks

Wrong language error in line 1.

Since when did Java declare methods like this: function timeDiff(time1, time2) ?

This looks like Javascript to me.