Hey Bill,

What I'm going with is just bringing over the date/time value over from SQL Server, then using a flag in several of my classes that handle dates to handle the date/time to date issue. My users just don't want to see the time portion of the date/time value.

Doug

>>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,