Hello all,
I am trying to use an sql query in the function insert to write a datetime to an ODBC database. 

I have no trouble with statements like: 
insert(obj.connection,table,{'"Record ID"','Name'},{1002,'Steven'}), where I'm writing 'Steven' to the "Name" field of the 1002 record. 

But when I try: 
insert(obj.connection,table,{'"Record ID"','DateTime'},{1002,'11/12/2010 08:47 AM'}) I get the error

[ODBC] Invalid operand for operator: <assignment>. 

I have tried putting the value for the date in many different forms (as datenum, as string of various mm/dd/yy formats, etc.) but always get the same error. If this helps, the exact database field is a Date/Time field in Quickbase, and we're using some third-party software (QuNect) to make Quickbase look like an ODBC to MATLAB. 

Thanks in advance for your help!! 
Graeme