create expiredDate using a createDate() function. then you'll be able to use dateAdd(), dateFormat(), etc.
<cfset variables.expireDate = createDate(2006, 11, 14) /> On 11/6/06, Orlini, Robert <[EMAIL PROTECTED]> wrote: > 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:259347 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
