You should be able to do: fix(tomorrow) - fix(now()) = diff in days
CF stores dates as a float, where the integer is the day value and the decimal values are represent the time. So, if you just round down and subtract the two dates you'll get the difference in whole days. -Dan >-----Original Message----- >From: Dawson, Michael [mailto:[EMAIL PROTECTED] >Sent: Tuesday, November 04, 2008 8:02 AM >To: cf-talk >Subject: RE: CF DATEDIFF Function > >Exactly. An entire day must expire before it can be counted. To expand >that, an entire "time period" must expire before it can be counted. >This includes years, months, days, hours, minutes, seconds, etc. > >If you want to count "today", just add one or use a different time >period as Paul suggests. > >Mike > >-----Original Message----- >From: Paul Hastings [mailto:[EMAIL PROTECTED] >Sent: Monday, November 03, 2008 8:39 PM >To: cf-talk >Subject: Re: CF DATEDIFF Function > >Azadi Saryev wrote: >> because your server time is different from your computer's time? your > >well there's that or that dateDiff returns results for *whole* days (or >whatever). try using hours. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
