Same syntax, you would just replace "now()" with whatever date (or string which can be converted into a date) that you wish to start from.
~Brad -----Original Message----- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Monday, November 06, 2006 2:21 PM To: CF-Talk Subject: expiredate minus 7 days How do I get a one week before date on a date value I have entered in a database already? This works for one week earlier on today's date <cfset mydate = dateformat(now()-7, "dd" ) /> How about a date I set? Such as: <cfset expiredate = '11/14/2006'> Robert O. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259350 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
