don't believe you need the dateFormat() either. dateDiff doesn't particularly care what format a date's in.
<cfset number = dateDiff('d', createDate(2006, 12, 12), now()) /> On 12/18/06, Jake Churchill <[EMAIL PROTECTED]> wrote: > 1: you don't need # inside cfset unless you're in a string. > 2: you need ticks around d ('d') > > [EMAIL PROTECTED] wrote: > > Why is this not working? > > > > <CFSET number = #DateDiff(d, dateformat(12/12/2006 1:36:51 PM, > > "MM/DD/YYYY"), dateformat(now(), "MM/DD/YYYY") )#> > > <cfoutput>#number#</cfoutput> > > > > ERROR > > The following information is meant for the website developer for debugging > > purposes. > > > > Error Occurred While Processing Request > > Missing argument name. > > When using named parameters to a function, every parameter must have a name. > > The CFML compiler was processing: > > an expression beginning with "#", on line 9, column 17.This message is > > usually caused by a problem in the expressions structure. > > a CFSET tag beginning on line 9, column 2. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264387 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4