for your date that's already in the database...
dateAdd('d', -7, myQuery.myDateValue)
(sorry, i prefer dateAdd() over the syntax of myDate = myDate - 7) :)
On 11/6/06, Charlie Griefer <[EMAIL PROTECTED]> wrote:
> 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:259351
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
