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