timeDiff function was working perfectly and them just stopped working

[citigirl]

I created a form and a grid that included a timeDiff function that performed perfectly for quite a while. It is the exact timediff function that is described in the videos.

Now it simply doesn't work in either place. It appears that the function will only calculate the difference between two dates in hours. For example, my start date is 3/3/2015 12:00pm and my end date is 3/3/2015 3:00pm with a 0 response. If I change the end date/time to 3/4/2015 3:00pm it returns 24hours.

JavaScript is still new to me so I need simple instructions. If someone has an answer that helps me understand why the function would simply stop working.
I may also be helpful to mention that I started a simple grid in a different app and the function does not work there either.

Here's the function.


function timeDiff(time1, time2) {

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

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

[citigirl]

Re: timeDiff function was working perfectly and them just stopped working

I meant to add that I am using v12.

[TheSmitchell]

Re: timeDiff function was working perfectly and them just stopped working

Date.parse doesn't like "am" or "pm". It returns NaN when it encounters these values. Drop "pm" from your strings and see if that gets you closer to what you expect.

[citigirl]

Re: timeDiff function was working perfectly and them just stopped working

I really appreciate your quick response. Thanks.

Tried creating a new form and testing the timeDiff in that form and in a grid. Did not work. Obviously this is a little frustrating as I have 4 MS Access forms that I need to convert to Alpha and they all need this functionality.

[TheSmitchell]

Re: timeDiff function was working perfectly and them just stopped working

Can you post your testing form here?

[Clint2]

Re: timeDiff function was working perfectly and them just stopped working

I created a form and a grid that included a timeDiff function that performed perfectly for quite a while. It is the exact timediff function that is described in the videos.

Now it simply doesn't work in either place. It appears that the function will only calculate the difference between two dates in hours. For example, my start date is 3/3/2015 12:00pm and my end date is 3/3/2015 3:00pm with a 0 response. If I change the end date/time to 3/4/2015 3:00pm it returns 24hours.

JavaScript is still new to me so I need simple instructions. If someone has an answer that helps me understand why the function would simply stop working.
I may also be helpful to mention that I started a simple grid in a different app and the function does not work there either.

Here's the function.


function timeDiff(time1, time2) {

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

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

The fact that it only changes when you change the day implies it's only looking at the date and that's why when the date changes by 1 day, you get 24 hours.

Is the grid editable and you want the calculations to occur as the move from field to field OR could they hit submit and calculate then?

Is it a text box they just type in and you hope formatting is good? If so could you break it into a date and time text box and use date and time pickers to assure error free editing?

If you can live with a trip back to the server, you can use xbasic instead of javascript.

[GGandhi]

Re: timeDiff function was working perfectly and them just stopped working

if you post your testing form or grid as sarah has suggested you will get an answer, I am sure.