You'll want to put quotes "d" around the d. It's looking at d as a varialble without them.
t ********************************************************************** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ********************************************************************** -----Original Message----- From: Eric J Hoffman [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 5:24 PM To: CF-Talk Subject: dateadd problem ok, what obvious deal have I missed? <cfset newdate = #createODBCdate(now())#> <cfset finaldate = dateadd(d, -2, newdate)> <cfoutput> #finaldate# </cfoutput> I get an error resolving "d" it says...trying to find the datee two days from today and delete everything from the database later from that date back. Eric J Hoffman Director of Internet Development Small Dog Design, LLC www.smalldogdesign.com Home of MN Vikings Fans Worldwide! www.purplepride.org ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
