Definitely Use DateAdd().
Robert B. Harrison Director of Interactive services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be &. -----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, July 16, 2007 10:30 AM To: CF-Talk Subject: RE: createodbcdate That should work. I've done the same thing with DateFormat. Try DateAdd(). -----Original Message----- From: Peter Tanswell [mailto:[EMAIL PROTECTED] Sent: Monday, July 16, 2007 9:15 AM To: CF-Talk Subject: createodbcdate Hi there I am trying to finish an application. I want to create two dates - a start date and and an ending date which is 5 days after the start date. I have #CreateODBCDate(eventdate)#, for creating the start date and I tried to use #CreateODBCDate(eventdate)+5# for the end date - but it did not like this - just wondering if anyone has any ideas. Thanks in advance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283753 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
