Alex,

You can always just run another VFP select on the SPT result and do the datetime to date conversion.

>Thanks, David. I mostly can ignore it except when doing date arithmetic. (Wonder if printing might give some trouble also).
>
>Ideally I wouldn't have to change any legacy code. If necesary I'll create a JustDate function and insert it in the places that give trouble. Hopefully that can be somewhat automated becasue I've been pretty consistent with naming conventions.