>>I'm not sure but I think it works with remote views only.
>
>>>Changing DataType of the field from T to D in the local view doesn't seem to work. In other words, the field remains T. Is it a bug in VFP8 or did I do something wrong?
>>>
>><snip>
>
>I have not try with remote view, but I am sure and try that datetime field in SQL I become field in format (D) in VFP Cursor, when I use cursorshema for this Field with format (D) (when I use CA).
>
>HTH

Yes, CA should work. We're currently debating an idea of switching to CA in our application.