Webmaster Forum / ColdFusion / Getting Started / September 2004

I'm having problems inserting a Date and Time into a Microsoft Access 2000
Database field that is formatted as 'DateTime'. Here's some sample code of what
I'm trying:

<cfset DateTime = CreateODBCDateTime(Now())>

<cfquery name="InsertOrder" datasource="#Request.MainDSN#">
INSERT INTO Orders(
  OrderDate
)
VALUES(
  '#DateTime#'
)
</cfquery>

If I take a look at the variable DateTime it contains "{ts '2004-09-29
15:16:54'}".
Is it supposed to have the curly braces and 'ts' prefix? Access2000 certainly
won't accept it. Can anyone point out what I'm doing wrong?

Thanks in advance,

Dave