>I am trying to pass a datetime in my SQL INSERT statement that I'm building using VBscript in an .asp page to a VFP free table. Has anyone been susccessful in passing a datetime via an INSERT..? My SQL is "INSERT INTO company (datetime,...) VALUES("",...)". Within the "" I'm putting the results of the NOW function. The column in my VFP table is a datetime type. I can pass the datetime using the commmand.parameter... of ADO.
>
Just a SWAG, but have you tried formatting the result in the VFP StrictDate format, e.g.

{^2001-03-31 13:12:06}

Note that you probably don't want that enclosed in quotes.