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:255595 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
