Cetin,
Sorry but I don't understand your advice...

I know that I can change the type from a Cursor doing this..

nID = SQLSTRINGCONNECT("DRIVER=SQL SERVER;SERVER=BOSS700;UID=sa;PWD=sa;DATABASE=Northwind")
IF nID > 0
	csql = "SELECT Employees.EmployeeID, Employees.LastName, Employees.FirstName," + ;
		"Employees.Title, Employees.TitleOfCourtesy, convert(char(10),Employees.BirthDate,103)as Birthdate," + ;
		"convert(char(10),Employees.HireDate,103)AS Hiredate, Employees.Address, Employees.City, Employees.Region," + ;
		"Employees.PostalCode, Employees.Country, Employees.HomePhone," + ;
		"Employees.Extension, Employees.Photo, Employees.Notes," + ;
		"Employees.ReportsTo, Employees.PhotoPath FROM dbo.Employees WHERE Employees.EmployeeID = codigox"
		
	a =SQLEXEC(nID,csql, "Employees")
ENDIF

This sample above I use the convert function in SQL Server, but I would like to return the cursor
without a datatype change in SQL, but use a method in VFP that changes each field in the cursor to
Date, so the field in the form only shows the Date and not a datetime value.
Or find a way to make the field in the form to show only the Date of a Datetime field.

Thanks

Peter