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.