DateDiff requires 2 dates. The inside datediff is now no longer a date it is an integer of the datepart you specified. So you should be getting an error stating something of that nature.
So, what is it that you are trying to do? Chuck Weidler Lockheed Martin Information Technology 3108 Lord Baltimore Drive Baltimore, MD 21244 Voice: (443) 348-2169 Fax: (443) 348-2233 Email: [EMAIL PROTECTED] -----Original Message----- From: Nick G [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 2:05 PM To: CF-Newbie Subject: DateDiff variables Instead of delcaring a variable like this: <CFSET myTime = #DateDiff("d", ENDDATE, PENDINGDATE)#> I have been trying to put a datediff inside a datediff..see below. <CFIF COMPLATEDATE NEQ "" AND SIGNEDDATE NEQ ""> #Datediff("d", #DateDiff("d", ENDDATE, PENDINGDATE)#, INITIALDATE)# Days </CFIF> .....is this possible or should I just use the myTime variable ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2539 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
