writing Notes datetime field via SQL statement

[yert33]

Notes R5. Trying to write to a Notes Date/Time field with these attributes: editable, Notes style, display sample: 08/15/02 09:58:32 AM.

Using this SQL statement:
INSERT INTO Mainform (logdate) VALUES (08/15/02 09:58:32 AM)

Get this ODBC error: Comma or right parenthesis expected.

(This SQL statement is being sent through VisualFoxPro 6.0. Writing to text, radio button and and checkbox Notes fileds has been no problem.)

What syntax does Notes want to see an SQL datetime value?

 

[yert33]

wgcs solved in the VFP forum look here thread184-337566