Hi All,

Can anyone direct me or provide advice on how I can assign a null value to a
date variable in vb.net.
Basically what I'm doing is that I'm looping through a recordset where I
have three date fields that may or maynot have date values, if no date values
exists in the source field, the value is null. but when I pass a record from
the recordset to SQL command parameter query for record insertion into a
different table, the date values that are blank are inserting a date stamp of
00/00/1900 00:00:00 into my destination table. So is there anyway that I can
assign a null value to vb.net date variable so that when the date field is
blank a null value is inserted by my SQL insert statment.

many thanks,
Liamo

"Liam Mac" <LiamMac (AT) discussions (DOT) microsoft.com> wrote

What constraints are defined for the field in question in the database
table?

"Liam Mac" <LiamMac (AT) discussions (DOT) microsoft.com> wrote

This article may be helpful:

http://msdn.microsoft.com/library/de...mberstopic.asp

Try using sqldatenull. I have used this code and it worked for me, see sample below, hope this helps:

sql.commandtext="insert into TEST_TABLE (datefield) VALUES (@DATEVALUE)"

If (datefield = "") Then
sql.Parameters("@DATEVALUE").Value = sqldatenull
Else
sql.Parameters("@DATEVALUE").Value = datefield
End If

Use the DBNull.Value in your SQL Query. That should work.