Unfortunately, I don't think there is any easy way to it.
>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
- Jayesh