If you're inserting into a datetime field/column,
VALUES(#CreateODBCDateTime(Now())#) will work.
best, paul
At 01:26 PM 4/29/00 -0500, you wrote:
>Your code is Perfect (although I like putting a ; after the values line.)
>You need to change the field name to something other than DATE (like maybe
>"DateEntered"). Then it will work.
>
>Fred
>
>----- Original Message -----
>From: "Brian Ingram" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Saturday, April 29, 2000 11:43 AM
>Subject: Inserting the Date in Access????
>
>
> > I've been having problems inserting the CurrentDate in Access as well.
>I've tried setting the data type up as a text and as a date/time, but
>neither work.
> >
> > What is the best way to do it?
> >
> > When i try to insert the date i get this error:
> > ===========================
> > ODBC Error Code = 37000 (Syntax error or access violation)
> >
> > [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
>statement.
> > =========================
> >
> > I've checked my syntax about a million times (it's right), but it still
>wont work.
> >
> > If this helps this is the code i'm trying to do it with:
> >
> > <CFSET CurrDate = "#DateFormat(now(), "MM/DD/YYYY")#">
> >
> > <CFQUERY DATASOURCE="whatever">
> > INSERT INTO Review(Date)
> > VALUES ('#CurrDate#')
> > </CFQUERY>
> >
> > thanks in advance for your help,
> > brian
> > -----------------------------------------------
> > FREE! The World's Best Email Address @email.com
> > Reserve your name now at http://www.email.com
> >
> >
> > --------------------------------------------------------------------------
>----
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
