Hi Jayesh

In the end I opted for your 2nd suggestion, so I'm glad I wasn't missing something.

Is there a quick and simple way to do the first one? it sounds like I'd have to construct the insertcommand differently upon checking the value in the date field?

Thanks
Kev

>There are two work arounds.
>
>1) Do not include Date column in Insert/Update if it is not filled in.
>2) Write trigger on Fox table and make it {/} if it is 01/01/0001.
>
>
>>Hi
>>
>>How can I place an EMPTY Date into a fox date field from VB.Net using OLEDB, whenever I issue an empty Date variable to a field, it comes out as 01/01/0001 in Fox.
>>
>>How can I ensure the format is / / ?
>>
>>Thanks
>>Kev