>Hi
>
>'2005-01-01' should work
>
>If not, can you post error message?
>What type is reference?
>
>You can also try with parameters and let VFP and ODBC do the cast
>dDateIns = date()
>

>?sqlexec(nHandle, "insert into table1 (reference, date) values;
>  ('23422',?dDateIns)")
>

Probably he is not reading the replies:)
Cetin