Hi Chuck, this is part of a table which the user than will be able to save in Excel or a PDF file. I am changing the table to indicate how much time (in days) it takes for each phase to be completed. There are a lot of dates and 12 phases in all. I was trying to create a short cut by putting two DateDiff's together which was supposed to help me cut out several nested if statements (which is not my strong point).
>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:2541 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
