Date and Time problem

[Dinghus]

I have an Access database with a field of type DATE/TIME and when I try to insert a date I get a data conversion error.

Here is the query, any ideas?

<cfquery name = &quot;add_speaker&quot; datasource=&quot;mydata&quot; dbtype=&quot;ODBC&quot;>
INSERT INTO mytable (
first_word,
last_word,
date_added
)
VALUES (
'My',
'Bad',
<CFQUERYPARAM VALUE = &quot;#CreateODBCDate(Now())#&quot; CFSQLTYPE=&quot;CF_SQL_DATE&quot;>
</cfquery>

 

[GunJack]

I think this will fix it.

<cfquery name = &quot;add_speaker&quot; datasource=&quot;mydata&quot; dbtype=&quot;ODBC&quot;>
INSERT INTO mytable
( first_word, last_word, date_added )
VALUES ( 'My', 'Bad', #CreateODBCDate(Now())#)
</cfquery>

GJ

 

[tleish]

You may want to use #CreateODBCDateTime(Now())# instead of #CreateODBCDate(Now())# if you want the current time as well.