Pete,
        What Anthony was attempting (I believe) to
show you is you can use the dateadd function and
increment the current date (i.e. Now()) by "x"
amount and compare the result in the if statement.

So, if you used today's date formatted like:
10/11/2000 13:40:00 and used the dateadd
function like Anthony suggested in his
response to you,

> <cfif now() LTE dateadd("d","30","10/11/2000 13:40:00") and complete is
"true">

it would return:

11/10/2000 00:00:00

and then you can execute the cfif.

Simple eh ? :-)

The CF help files that are accessible from
the studio I use all the time.  Do a search
there on "date" and view the "date and time
functions" that will come up, or just search
dateadd.  Either way, it shouldn't be hard to
find.

Cheers :-)

Ryan Williams
[EMAIL PROTECTED]
301-397-2860

P.S. "Remember, it isn't what you do correct, but
what you screw up that is important to your peers"
- Anonymous


-----Original Message-----
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 11, 2000 12:05 PM
To: CF-Talk
Subject: RE: cfif


I don't know enough yet to keep it simple :)

thanks!

-Pete

*  -----Original Message-----
*  From: Anthony Geoghegan [mailto:[EMAIL PROTECTED]]
*  Sent: Wednesday, October 11, 2000 10:54 AM
*  To: CF-Talk
*  Subject: RE: cfif
*
*
*  Hi Pete,
*  Like this.
*  <cfif now() LTE dateadd("d","30",due) and complete is "true">
*  Keep it simple.
*
*  -----Original Message-----
*  From: Peter Benoit [mailto:[EMAIL PROTECTED]]
*  Sent: 11 October 2000 15:43
*  To: CF-Talk
*  Subject: RE: cfif
*
*
*  Well here is all the offending code
*
*  <cfset datedue=#DateFormat(#due#, "m/d/yy")#>
*  <cfset nNow=#DateFormat(Now(), "m/d/yy")#>
*  <cfset difference=#DateDiff("D", nNow, datedue)#>
*
*  <cfif difference IS NOT LT -30 AND complete IS "true">
*
*
*  I'm not sure how I'd use your example with this.
*
*
*  -------------------------------------------------------------
*  -----------------
*  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
*  To Unsubscribe visit
*  http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lis
ts/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.mail-archive.com/cf-talk@houseoffusion.com/
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