It's on a Query of Queries, so no cfqueryparam - boooo... :( T
On 23 May 2007, at 15:33, Ben Nadel wrote: > You should also check out CFQueryParam for timestamp in combo with > date > math: > > Date < <cfquaryparam value="#Fix( Now() + 1)#" > cfsqltype="CF_SQL_TIMESTAMP" /> > > The Now() + 1 will get you into tomorrow. > > The Fix() on that date will strip out the time and create an integer > date. > > The CFQueryParam will convert your integer back into a SQL date/time > stamp (with zeroed out time). > > This way has been awesome for me in the past. Here are some > potentially > useful date posts: > > > http://www.bennadel.com/blog/226-ColdFusion-Date-Math-Faster-Than- > Date-M > ethods-And-Other-Date-Math-Ramblings.htm > > http://www.bennadel.com/blog/193-Adding-Numbers-To-Date-Time- > Values.htm > > http://www.bennadel.com/blog/150-Ask-Ben-Appending-Times-To-Date- > Time-Ob > jects.htm > > > ...................... > Ben Nadel > Certified Advanced ColdFusion MX7 Developer > www.bennadel.com > > Need ColdFusion Help? > www.bennadel.com/ask-ben/ > > -----Original Message----- > From: Tom King [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 23, 2007 8:54 AM > To: CF-Talk > Subject: Re: Date < now() +1? > > Thanks all, > the #dateAdd('d', -1, Now())# > > does what I need in both instances! > > > :) > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278985 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
