Make it a date/time field and then use CreateODBCDate(Now()) for just the date,
with a "time" of midnight, or use CreateODBCDateTime(Now()) to store the current
time. I believe you don't use quotes around an ODBC date or date/time value in
a SQL statement.
Jim
-----Original Message-----
From: Brian Ingram <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Saturday, April 29, 2000 10: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.
