Hi,

How can I subtract one month (30 days) from a value?

The coding I have is: 

<CFIF #get.enddate# eq #dateformat(now(),"YYYYMMDD")#>
Yes
<cfelse>
NO
</CFIF> 

and they equal Yes all the time.

Both these values check out OK and appear as: 20070927 
But I need the #dateformat(now(),"YYYYMMDD")#> to go back one month
I tried <CFSET expire = #dateformat(now(),"YYYYMMDD")#> 
and then 
#DateAdd("d", -30, expire)# but it displays as {ts '56852-03-30 00:00:00'}
Thanks in advance.
Robert O.
HWW



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289639
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to