>I have a remote view with a datetime field that I would like to change to a simple date field before the user gets a hold of it. The problem I'm running into is that I have used an alias name in the data environment and the DBSETPROP(alias.fieldname, "FIELD","DATATYPE","D") is ignored (even though it returns .T.). Does anybody know how to reference the fieldname properly?
>
>Thanks

You can get the name of the underlying view first like:

lcViewName = CURSORGETPROP("SourceName","Alias")

DBSETPROP(lcViewName + "Yourfieldhere", "FIELD","DATATYPE","D")