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

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:

Subtracting 7 days less than Now() date?

Using this: CFSET DATETODAY=DateFormat(Now(), ", dd, ") 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

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

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(), ",

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

--=_11998565==_.ALT Content-Type: text/plain; charset="us-ascii" Try this: #DateFormat(DateAdd('d', -7,NOW()), ", dd, ")# At 08:19 PM 5/16/00 -0400, you wrote: Using this: CFSET DATETODAY=DateFormat(Now(), ", dd, ") How would I subtract 7 days