The only issue I ever had w/ DateDiff was when I went over MAXINT doing
a DateDiff over 80 or so years and returned it as seconds. Although in
the case you describe below, I bet it's something else. Before the
datediff, try parsing the dates to get the years, months, etc, and
output them. I bet the years are wrong.
=======================================================================
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email : [EMAIL PROTECTED]
Yahoo IM : morpheus
"My ally is the Force, and a powerful ally it is." - Yoda
> -----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 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
> TotalTime: 353173193 minutes
>
> Anyone had any trouble with CF's DateDiff function?
> 353Million minutes is
> not the right answer... :)
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
