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.

Reply via email to