Yup - that's it. Thanks
----- Original Message ----- From: "Jim McAtee" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 19, 2001 10:47 PM Subject: Re: Subtract Time > If you really mean that date/time value is in a CF variable, then the > easiest way is > > <cfset dt = dt - 1/24> > > The "official" way to do it is probably > > <cfset dt = DateAdd("h", -1, dt)> > > > Jim > > > ----- Original Message ----- > From: "David Hannum (Ohio University)" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, December 19, 2001 8:24 PM > Subject: Subtract Time > > > > If I have a time in a database as such: > > 1899-12-30 10:00:00 > > And I want to subtract 1 hour from that, what's the best way? > > > > Thanks, > > Dave > ______________________________________________________________________ Dedicated Windows 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=coldfusiona 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