DateDiff Problems

Has anyone run into strange problems with DateDiff function? Im getting some strange problems where only a 3 hour difference reports as 3 million minutes. 99% of the time DateDiff works, but every once and while it messes up and reports a very large number of minutes. CF 4.5.1 SP2 on Win2K My

DateDiff problems

My email didnt seem to hit the list. Sorry if this is a re-post. Im doing a CF DateDiff function on two ODBC compliant date times and every once and a while i get very strange results. I found this one in the MySQL database: Clockin: 2001-09-04 12:06:08 Clockout: 2001-09-04 15:19:51 TotalTi

RE: DateDiff problems

--Original Message- > From: Chad Gray [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 06, 2001 3:31 PM > To: CF-Talk > Subject: DateDiff problems > > > My email didnt seem to hit the list. Sorry if this is a re-post. > > Im doing a CF DateDiff function on two O