>Hi,
>Anyone know why when I access a date field from a VFP table the DataAdapter returns a datetime instead of just a date? Or does someone know how to fix this - all I want is just the date (this is for a DOB field).
>
>TIA
>John

Pure DATE type is specific to FoxPro (it might also exist in some other systems, I guess). Practically you may say that DATETIME is more or less standard for dates exchange. For example, you might get a data type error if you return DATE type value from VFP COM object to VFP application and try to treat the received value as DATE. You will actually receive the DATETIME as it is the standard type for COM data exchange.