>Is there a way via SQL-pass-thru to return a table from SQL Server with datetime fields as dates?
>
>Would creating a datatype on SQL Server to limit the portion of the datetime field to just display the date be an option?
>
>Thanks
>Doug

Hi Doug,
As Arne said, with SPT, it is a 2-step process to get a VFP date datatype. However, with Remote Views, you can define the datatype. Just another option. I use a combination of SPT and RV in my applications.
HTH,