Hi Sergey,

Thank you for the replay. How can I assign a Null value to a date field in VFP.

Ali

>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.