>>
>>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.
>
>Thank you for your help.
yep it's a T-SQL function, i should've been clearer
e.g.
** vfp code
SQLEXEC(lnHandle, "select convert(smalldatetime, convert(varchar, date_col, 101)) as date_col, etc...")
Insanity: Doing the same thing over and over and expecting different results.
