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]

Reply via email to