That's what I ended up having to do. Thanks for the input!
>I haven't tried it Mike, because we don't pass NULLs to our Procs, but are you setting the parameter to DBNull.Value? I think just plain old null (or nothing as you VB guys like to say <g>) isn't going to work.
>
>~~Bonnie
>
>>>>I am getting a StrongTypingException when I try to pass a NULL date into my SPROC. What is the preferred way of doing this? I know I can set the default value in the SPROC and just not pass the parm, but is there a way to specifically pass a NULL date?
>>>>
>>>>Thanks!
>>>
>>>dim myDate as Nullable(of DateTime)
>>>
>>>should work in VB but I'm not sure.
>>>
>>>Cetin
>>
>>So I can pass a nullable datetime variable as a parameter into my SPROC?