what was it about dateAdd() that was throwing you? still have questions about its usage?
On 10/4/06, Mark Leder <[EMAIL PROTECTED]> wrote: > That worked. Thanks for the quick help. > > > Thanks, > Mark > > -----Original Message----- > From: Matt Williams [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 04, 2006 10:08 PM > To: CF-Talk > Subject: Re: Date Add > > <cfset myDate = DateAdd('d',14,Now()) /> Then in your query: > #CreateODBCDateTime(myDate)# > > Can also be combined to one statement: > #CreateODBCDateTime(DateAdd('d',14,Now()))# > > > On 10/4/06, Mark Leder <[EMAIL PROTECTED]> wrote: > > How do I take a current date/time "#now()#" and add a number of days > > to it, such as 14 days into the future, then convert to > > #CreateODBCDateTime()# so I can stick in a db? > > > > Can't find anything on cflib, and I'm confused by the syntax of > dateAdd()... > > > > Thanks, > > Mark > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255606 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
