because your server time is different from your computer's time? your server may be in a timezone where it is already 'tomorrow' while where you are it is still 'today', so now() on the server will return your 'tomorrow' date...
Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ LSD 4Me wrote: > Hi, > > Can anybody explain why the return value is '0' when determining the > difference in dates between today and tommorow? > > IE... > > <cfset showdiff = #datediff('d',now(),'11/04/2008')#> > > <cfdump var="#showdiff#"> > > What i interpret from the datediff statement is that I need the difference in > (days) between now() which is 11/03/2008 and 11/04/2008...Should be 1...Keep > getting 0. > > Any ideas? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:314795 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

