Use DateTime.MinValue, and then check to make sure the passed value is
greater than that inside the function body.
"Learning SQL Server" <no.mail.com> wrote in message
news:Ol****************@TK2MSFTNGP09.phx.gbl...
What should the default value for an optional Date parameter be in a
function if I want it to default to Nothing?
Setting the optional value to "" fails, so does setting it to Nothing.
Function blah(byval User as string, Optional byval UserDate as Date =
?????)
Thanks (again)