You don't format it. Just use a=#Now()#. Andy
-----Original Message----- From: Luis Lebron [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 9:56 AM To: CF-Talk Subject: Newbie question-Inserting the current date into Access 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
