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)")