myDateVar = Null
REPLACE myDateFiled WITH Null

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