Well, I did some experiments; I guess I am now using a patched version. So
applying the updater is probably the best idea.
<cfoutput>
<cfset startDate = parseDateTime("4/1/2005")>
<cfset endDate = parseDateTime("4/5/2005")>
DateDiff("d",#startDate#,#endDate#)
<h1>#DateDiff("d",startDate,endDate)#</h1>
DateDiff("h",#startDate#,#endDate#)
<h1>#DateDiff("h",startDate,endDate)#</h1>
<cfset startDate = parseDateTime("5/1/2005")>
<cfset endDate = parseDateTime("5/5/2005")>
DateDiff("d",#startDate#,#endDate#)
<h1>#DateDiff("d",startDate,endDate)#</h1>
DateDiff("h",#startDate#,#endDate#)
<h1>#DateDiff("h",startDate,endDate)#</h1>
</cfoutput>
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
....-----Original Message-----
....From: Les Mizzell [mailto:[EMAIL PROTECTED]
....Sent: Thursday, March 10, 2005 4:02 PM
....To: CF-Talk
....Subject: Re: DateDiff HUH???
....
....> When using the "d" value of datediff, it is using 24 hours as a day.
....Since we lose an hour on 4/3/2005, you are one hour short of 9 days, and
....the extra 23 hours are truncated.
....
....Hmmm - OK, is there a good fix for this? Or does it require a previously
....mentioned updater?
....
....--
....-----------
....Les Mizzell
....
....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198394
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
