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