Whoops... correction... only the first data is NOW... the others are
NEWDATE... it's cumulative.
<cfset newdate=#DateAdd('d',days_value,Now())#>
<cfset newdate=#DateAdd('m',months_value,newdate)#>
<cfset newdate=#DateAdd('yyyy',years_value,newdate)#>
Robert B. Harrison
Director of Interactive services
Austin & Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119
F : 631.434.7022
www.austin-williams.com
Great advertising can't be either/or... It must be &.
-----Original Message-----
From: Robert Harrison [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 02, 2008 3:07 PM
To: CF-Talk
Subject: RE: Please Help..Confused
If you mean X years, Y months, and Z days from NOW:
<cfset newdate=#DateAdd('d',days_value,Now())#>
<cfset newdate=#DateAdd('m',months_value,Now())#>
<cfset newdate=#DateAdd('yyyy',years_value,Now())#>
This will give you a new date that is x years, Y months, and Z days in the
future from now.
If you're calculating from a different date, change Now() to the start date.
If you're subtracting to find a past date, change the values to negative.
That will do it.
Robert B. Harrison
Director of Interactive services
Austin & Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119
F : 631.434.7022
www.austin-williams.com
Great advertising can't be either/or... It must be &.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311938
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
