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