http://dev.navtrak.net/dateDiffBug/anotherdatediffbug.cfm
thats what i came up with just before red sky beta...
tw
On Fri, 11 Mar 2005 11:06:55 -0500, Les Mizzell <[EMAIL PROTECTED]> wrote:
> Ian Skinner wrote:
> > Well, I did some experiments; I guess I am now using a patched version. So
> > applying the updater is probably the best idea.
>
> Shared server - host that SUCKS - client that *likes* the host anyway.
>
> ACK!!
>
> Below is very close to what I came up with last night. Both work fine.
>
> Thanks to all that replied to this one. It was an interesting problem...
>
> >
> > <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
> > ....
> > ....
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198416
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
