Hi!

No, because SQL Server does have only DateTime data type and no separate Date type as in VFP. You can do mapping in the VFP by using a remote view - in remote view designer open the field propertis, select the datetime field and change its type to date. When view opened, the query result in view will be mapped to specified field types if possible. Unfortunately, there are no way to do something similar with SQL Pass-Through cursors.

HTH.

>Hallo all
>I wonder if somebody have a solution on a dateproblem.
>I want the datepart of a datetimefield from an SQL server.
>Something like this:
>
>select "datepart of a datetimefield" as "datefield" from MySQLtable
>
>I hope you understand my question, I have looked everywhere for a simple solution on this.
>Of course I can convert the datetimefield in VFP later, after the SQL query is done, but are there some way to do the convert direct in the query.
>
>Thanks in advance
>/Kjell