Insert or update a Null value to a DateTime field

[skyplayer]

Is it possible to insert a Null value to a smalldate time field which is allowed Null in VB?
I have tried to assign vbNull and vbEmpty to it, but it prompts "The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error."
=======================================================
e.g.
rs.open...
rs!testdate = vbNull
rs.update ' -> prompt the error!
=======================================================
So what can I assign to the rs!testdate field in vb by ADO?

 

[Kendel]

Why don't you try rs!testdate = "" ?

 

[skyplayer]

I tried it, but still fail to assign,
the rs!testdate can't accpet empty string!

 

[Kendel]

Can you modify the testdate field so it would accept a Null value?

I guess "testdate" is a time-date data type so it won't accept an empty string. You can try some something like

rs!testdate = ## or rs!testdate = #00-00-00# ...

Sorry, can't help !

 

[CajunCenturion]

You might try the following construct:

rs!testdate = CDate(Empty) Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[Suraklyn]

CDate(Empty) returns 12:00:00 AM. --
Jonathan