Re: Newbie question-Inserting the current date into Access

2003-01-27 Thread Jochem van Dieten
,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

RE: Newbie question-Inserting the current date into Access

2003-01-27 Thread Neil.Robertson-Ravo
TED]] Sent: 27 January 2003 16:27 To: CF-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

RE: Newbie question-Inserting the current date into Access

2003-01-27 Thread ssnyder
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.

RE: Newbie question-Inserting the current date into Access

2003-01-27 Thread Andy Ousterhout
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 t

RE: Newbie question-Inserting the current date into Access

2003-01-27 Thread Luis Lebron
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

Re: Newbie question-Inserting the current date into Access

2003-01-27 Thread Jochem van Dieten
Luis Lebron wrote: > 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? INSERT INTO table (field) VALUES

Re: Newbie question-Inserting the current date into Access

2003-01-27 Thread Scott Brady
>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

2003-01-27 Thread Candace Cottrell
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 wit