How about: <cfset expiredate = '11/14/2006'> <cfset mydate = Dateformat(#expiredate#-7,"mm/dd/yyyy")>
Michael > > From: "Orlini, Robert" <[EMAIL PROTECTED]> > Date: 2006/11/06 Mon PM 08:20:51 GMT > To: CF-Talk <[email protected]> > 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:259354 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
