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.

Has anyone tried this and succeeded?

Thanks

Wayne Finch