I convert my datetime from sql to just a date to display in FoxPro. I use CONVERT(char(10), datefield,101) as newdatefield. This display only the date and I can update back to the server but when I try to delete a date it won't save. I don't get an error just does not save.

Any ideas on how to delete a date?