Thanks Naomi. I searched and found that if you are using remote views you can set a property so that datetime is converted to date. But I don't think that is available for Sql Passthrough.

As far as casting in vfp, I know that works, and I had already done that... but I was hoping to avoid the extra step. But it looks like it is unavoidable.


>>I read that the date data type was added to sql server in server 2008. For the following statement:
>>
>>lnr=sqlexec(lnh,"select cast(dt_date as date) as date_ from activity","curactivity")
>>
>>dt_date is a datetime data type. In the cursor curactivity, date_ become character (10), not vfp's data type date.
>>Is there anyway to directly convert this this vfp's date datatype?
>
>Try searching on this problem here, I believe the problem was discussed - we need to use some property to map.
>Alternatively, you may cast it in VFP side (reselecting data again).