I use '#DateFormat(Now(), "MM/DD/YYYY")#'
-----Original Message----- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 11:19 AM To: CF-Talk Subject: RE: Newbie question-Inserting the current date into Access 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 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
