Hi C.W.,
That does only return the Date portion, but then the datatype is Character. I need it to be VFP Date datatype.
It may not be possible without using a Remote View, but I've been suprised in the past... Thanks

>You can use a command in your SQL statement as follows:
>
>"convert(char(12),RM20101.DOCDATE,101)AS DOCDATE,"
>
>This gives you just the date portion of the field "char(12)". Also, read Convert() in SQL books online. The ",101" code(s) are important.
>
>
>C. W. Finch