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
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
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
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
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
-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
,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
7 matches
Mail list logo