Creating an Optional Date Parameter

Learning SQL Server

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)

Nov 19 '05 #1

Russell Jones

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:Ol7tI%23DbDHA.2368@TK2MSFTNGP09.phx.gbl...[color=blue]
>
> 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 =[/color]
?????)[color=blue]
>
> Thanks (again)
>
>
>[/color]

Nov 19 '05 #2