What about #DateAdd("d",-7,Now())#?
I think that does it... hope it helps.
David
Michael Imhoff wrote:
>
> WHERE calendar_depositions.depodate > startdate
>
> Depending on what database you are using because they don't all handle dates
> the same way, you might want to create the data 7 days ago and then use the
> Year, Day, and Month function along with the CreateDate function so that
> your times are correct.
>
> Just a thought,
> -Michael
>
> ========================================
> Michael Imhoff :::: www.omnicypher.com :::: icq: 10495667
> [EMAIL PROTECTED] (home) :::: (320) 255-4447 (home)
> [EMAIL PROTECTED] (cell) :::: (612) 247-8159 (cell)
> Allaire Alliance Consulting Partner
>
> ----- Original Message -----
> From: Tiffany <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, May 17, 2000 12:19 AM
> Subject: Subtracting 7 days less than Now() date?
>
> > Using this:
> >
> > <CFSET DATETODAY=DateFormat(Now(), "dddd, mmmm dd, yyyy")>
> >
> > How would I subtract 7 days from that date? I'm making a query where
> > data wont be displayed if it is 7 days less than that set date (above).
> >
> > Would something like this work?
> > WHERE Datetoday LT Now(-7)
> >
> > Ugh, I'm a newbie =P
> >
> > Thanks,
> >
> > *~Tiffany~*
> >
> > --------------------------------------------------------------------------
> ----
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> ------------------------------------------------------------------------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
