Howdy,
I am trying to accomplish the following:
dim DateSend as date
if txtDateSend.text = "" then
DateSend = dbnull.value
else
DateSend = txtDateSend.text
end if
however, the script screams about "Value of type 'System.DBNull' cannot be
converted to 'Date'." How do I send a Null back? This variable, DateSend, is
then sent to a stored procedure and written back to the database. I read
other posts on google groups stating users switched the variables from date
to string, then did a cast within the proc. Is this really the best
solution? Come on, Microsoft must have a way of loading an empty value into
a date object.
thanks!!
David Lozzi