Problem is that im not storing time with the date... Also, the return value is '0' for today, and tommorow...i.e....
Today #datediff(d,now(),now())# Tommorow #datediff(d,now(),now()+1)# I managed to resolve this with another solution... <cfset currentdate = #dateformat(now(),'mm,dd,yyyy')#> <cfset ddiff = (#currentdate# - #db_data#)> This returns the INT values i need to begin with (-,0,+) Thanks neways! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:314798 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
