Re: Subtracting 7 days less than Now() date?

Tue, 16 May 2000 17:43:55 -0700 

--=====================_11998565==_.ALT
Content-Type: text/plain; charset="us-ascii"


Try this:
#DateFormat(DateAdd('d', -7,NOW()), "dddd, mmmm dd, yyyy")#


At 08:19 PM 5/16/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.

Joel Richards
Web Developer
Brainstorm Industries
<http://www.brainstormin.net/>[EMAIL PROTECTED]
--=====================_11998565==_.ALT
Content-Type: text/html; charset="us-ascii"

<html><div>Try this:</div>
<div>#DateFormat(DateAdd('d', -7,NOW()), &quot;dddd, mmmm dd,
yyyy&quot;)#</div>
<br>
<br>
<div>At 08:19 PM 5/16/00 -0400, you wrote:</div>
<div>&gt;Using this:</div>
<div>&gt;</div>
<div>&gt;&lt;CFSET DATETODAY=DateFormat(Now(), &quot;dddd, mmmm dd,
yyyy&quot;)&gt;</div>
<div>&gt;</div>
<div>&gt;How would I subtract 7 days from that date?&nbsp; I'm making a
query where</div>
<div>&gt;data wont be displayed if it is 7 days less than that set date
(above).</div>
<div>&gt;</div>
<div>&gt;Would something like this work?</div>
<div>&gt;WHERE Datetoday LT Now(-7)</div>
<div>&gt;</div>
<div>&gt;Ugh, I'm a newbie =P</div>
<div>&gt;</div>
<div>&gt;Thanks,</div>
<div>&gt;</div>
<div>&gt;*~Tiffany~*</div>
<div>&gt;</div>
<div>&gt;------------------------------------------------------------------------------</div>
<div>&gt;Archives:
<a href="http://www.egroups.com/list/cf-talk" 
EUDORA=AUTOURL>http://www.eGroups.com/list/cf-talk</a></div>
<div>&gt;To Unsubscribe visit </div>
<div>&gt;<a 
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&amp;body=lists/cf_talk" 
EUDORA=AUTOURL>http://www.houseoffusion.com/index.cfm?sidebar=lists&amp;body=lists/cf_talk</a>
or </div>
<div>&gt;send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
</div>
<div>&gt;the body.</div>
<br>

<font face="Tahoma">Joel Richards<br>
Web Developer<br>
Brainstorm Industries<br>
<a href="http://www.brainstormin.net/">[EMAIL PROTECTED]</a></font></html>

--=====================_11998565==_.ALT--

------------------------------------------------------------------------------
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