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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists