>Alex,
>
>I think you'll have to use a CONVERT() function from the backend. Can you not just ignore the time portion once you get down to VFP?

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.

Thanks again.

Alex