Article ID: 137604 - View products that this article applies to.
This article was previously published under Q137604
This article has been archived. It is offered "as is" and will no longer be updated.
To retrieve a datetime column value as a date (mm/dd/yy), a data type conversion must occur. For example, Microsoft SQL Server does not have a date data type; dates are always stored in a datetime format. This article describes how to convert the remote datetime data type to a date value by using the DbSetProp function. In Microsoft Visual FoxPro 3.0, you cannot do this by using the user interface when you create a remote view.
Note In Visual FoxPro 7.0 and later versions, you can change the data type of a field by using the Data type list in the View Field Properties dialog box of the View Designer.
FoxPro Help: Client/Server Applications, Data Type Conversions, Changing Default Data Types when Downloading.
Language Reference, page 245, "Field Properties for Views."