If you are trying to insert into a Date/Time field you don't need to put
the #CreateODBCDateTime(now())# in ''.
It would be nice to see more of your SQL to help though.
Michael
At 03:09 PM 10/27/00, you wrote:
>I have a access database and I can't get the value of ,
>'#CreateODBCDateTime(Now())#', in my Insert statement to work. I get the
>error:
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
>operator) in query expression ''{ts '2000-10-27 14:49:50'}''.
>
>The field type is text and a length of 100.
>
>Is this the best way because long term I will search DateDiff of these
>fields...
>
>Any help?
>
>-Chris
>www.chris.com
>
>
>_________________________________________________________
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
>------------------------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
>a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Michael Slatoff
[www.BOXoFUSES.com]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]