try:
<cfif datediff("d",now(),dateadd("d",7, now())) gte 0>
Seven days have passed.
<cfelse>
Seven days have not passed.
</cfif>
make sure you test this, cause I didn't!
Brook Davies
At 08:19 PM 16/05/00 -0400, you wrote:
>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.