this datatype can contain almost anything
"Linda White" <linda...@emporiumonline.com> wrote in message
news:3a2901c19011$5b91cc50$35ef2ecf@TKMSFTNGXA11...
> I am new to Visual Basic and am faced with the task of
> reading records in a Foxpro database for specific dates.
> The field type is adDBDate. There must be some way to do
> this. I am able to connect and read records using the
> other fields, but not adDBDate type fields.
>
> Can anyone help?
Can you tell us more about what you mean when you say that you "can't read"
date fields in a Foxpro database file? I'm sure you don't mean that a
SELECT statement fails to retrieve them...
-Doug
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
timedate As Date The field type in the foxpro database is
adDBdate 133 (yyyymmdd). Looking at the raw date, it is
yyyymmdd format and the record exists.
>.
>
Select * from Brekfile where emplid = '086040' and timedate = '03/28/00'