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.
