Using Remote View or CursorAdapter object, you can convert DateTime to Date.
LOCAL oCA as CursorAdapter
oCa=NewObject("CursorAdapter")
oCa.DataSourcetype ="ODBC"
oCa.dataSource= SqlConnect(...)
oCa.SelectCmd="Select invoicedate, customer from invoicedate"
oCa.CursorSchema= "invoicedate d, customer c(10)"
oCa.cursorFill(.t.)
