CreateODBCDateTime puts the apostrophes by itself. That is the prob.
<Jaime/>
> -----Original Message-----
> From: Chris Johnson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 27, 2000 3:10 PM
> To: CF-Talk
> Subject: DateTime Stamp Problem
>
>
> 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]
------------------------------------------------------------------------------------------------
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]
