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:311936
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
