I tried it without any luck. However I found the following on cfhub.com that worked: #CreateODBCDate(Now())#
thanks, Luis -----Original Message----- From: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 10:06 AM To: CF-Talk Subject: Re: Newbie question-Inserting the current date into Access You need double quotes around the "yyyy/mm/dd/" Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 1/27/2003 10:56:11 AM >>> I have an Access table with a Date/Time field. I have tried to insert the current date in a variety of different ways but I always end up getting an error. This is the last thing that I tried #DateFormat(NOW(), 'yyyy/mm/dd')#. Any ideas? thanks, Luis R. Lebron Project Manager Sigmatech, Inc ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4