Hi Ali,

I don't know about Access but ODBC doesn't support empty dates. You may consider using Null's instead.

>Hi every body,
>
>Thanks for the reply. I have got a problem with access DATETIME fields. While they have none blank values they work great. However, when I try to empty a DATETIME Access field through ODBC in VFP6, I get the following error:
>
>Connectivity error: [Microsoft][ODBC Microsoft Access Driver]
>Data type mismatch in criteria expression.
>
>How can I fix this problem?
>
>Thank you,
>Ali
>
>
>
>
>
>>>Hi every body,
>>>
>>>I have a question for you. I am accessing an Access database through ODBC. What is the equivalent of ‘Short Date’ in FoxPro?
>>>
>>>Thank you,
>>Ali,
>>
>>You can run select through ODBC and check what data type FoxPro uses for a ‘Short Date’ field in the cursor created.