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(), '/mm/dd')#. Any ideas? thanks, Luis R. Lebron Project Manager Sigmatech, Inc

Re: Newbie question-Inserting the current date into Access

You need double quotes around the /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

Re: Newbie question-Inserting the current date into Access

This is the last thing that I tried #DateFormat(NOW(), '/mm/dd')#. Any ideas? Instead of using CF to insert the current date, you can use the Access SQL version, which I believe is Now(). INSERT INTO yourTable ( theDate ) VALUES ( Now() ) I haven't done it in Access in a while and each

RE: Newbie question-Inserting the current date into Access

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

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

RE: Newbie question-Inserting the current date into Access

I use '#DateFormat(Now(), MM/DD/)#' -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

RE: Newbie question-Inserting the current date into Access

-Talk Subject: RE: Newbie question-Inserting the current date into Access I use '#DateFormat(Now(), MM/DD/)#' -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

Re: Newbie question-Inserting the current date into Access

,Neil (RX) wrote: dont do it using CF, let Access enter the data using Now() as a default value, its one less SQL Transaction to doand it saves typing And it kills code portability. If you do it using a DBMS built-in command, use the SQL standard CURRENT_TIMESTAMP (if Access supports