Here is another posting about a similar issue. This was helpful for us, hope it helps:
http://www.c-sharpcorner.com/Code/2003/Sept/EnterNullValuesForDateTime.asp
I found it better in a SP vs in vb.net anyway.
try something like this instead, see how it works for ya:
dim objDate as Object
dim sqldatenull as SqlTypes.SqlDateTime
sqldatenull = SqlTypes.SqlDateTime.Null
If Me.txtADate.Text = "" Then
objDate = sqldatenull
Else
objDate = Me.txtADate.Text
End If
Hope that helps...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.