>>
>>select convert(smalldatetime, convert(varchar, date_col, 101)) as date_col...
>>and then deal with date display/calculations in the VFP code, e.g., if you have to calculate date difference between dates, etc. Of course, if you need that kind of calculation, you could also let SQL Server handle that, as well.
>
>I am not familiar with the function convert() so I will have to look it up. It must be a SQL Server function as I don't see it in the VFP 8 help.
If you're using SQLEXEC(), you have to use SQL (or whatever backend) syntax, not VFP syntax. So yes, CONVERT would be a SQL function, not a VFP one.
