>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

Isn't DATEPART T-SQL function appropriate for your need?