>>I'm trying to insert a row into a foxpro table.
>>When inserting a date value into a foxpro table, what must I convert the value to before I can do an insert?
>>
>>I've tried this (and various combo of others)
>>

>>dDel_date =DateTime.Parse(TRow["del_date"].ToString().Trim()).Date
>>

>>and it didn't work.
>
>Can you also post your SQL code that does the insert?

After I do this,

cDate = DateTime.Parse(TRow["del_date"].ToString()

I tried

strQry = "insert into customer (fname, lname, orddate) "
strQry +="values ('"+cfname+"', '"+clname+"', '"+cDate+"')";

Then after this

dDate =DateTime.Parse(TRow["del_date"].ToString().Trim()).Date

I tried

strQry = "insert into customer (fname, lname, orddate) "
strQry +="values ('"+cfname+"', '"+clname+"', "+dDate+")";

Either way it won't go into a foxpro DATE field. However, they can both go into foxpro Character field.

Thanks Michel.