Nick,
Since you want to find the difference between ENDDATE and PENDINGDATE and get
the difference of that result of the difference between ENDDATE and
INITIALDATE. I hope I said that right. LOL
You can do something like this.
<CFIF COMPLATEDATE NEQ "" AND SIGNEDDATE NEQ "">
<!--- This creates a date of the ENDDATE plus or minus the difference of
PENDINGDATE. --->
<cfset myTempDate = DateAdd("d", DateDiff("d", ENDDATE, PENDINGDATE),
ENDDATE)>
#Datediff("d", myTempDate, INITIALDATE)#
Days </CFIF>
________________________________
From: Nick G [mailto:[EMAIL PROTECTED]
Sent: Tue 2/13/2007 6:32 AM
To: CF-Newbie
Subject: Re: DateDiff variables
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:2542
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
