Default a parameter to todays date

How can I set the default of a datetime parameter to be todays date?
Thanks,
AidanDId you try =Today() or =Now() ?
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Aidan Garnish" <aidan.garnish@.waterstons.co.uk> schrieb im Newsbeitrag
news:OUvRiODaFHA.1088@.TK2MSFTNGP14.phx.gbl...
> How can I set the default of a datetime parameter to be todays date?
> Thanks,
> Aidan
>|||That's great cheers
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:uxNaGkDaFHA.1040@.TK2MSFTNGP10.phx.gbl...
> DId you try =Today() or =Now() ?
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Aidan Garnish" <aidan.garnish@.waterstons.co.uk> schrieb im Newsbeitrag
> news:OUvRiODaFHA.1088@.TK2MSFTNGP14.phx.gbl...
> > How can I set the default of a datetime parameter to be todays date?
> >
> > Thanks,
> >
> > Aidan
> >
> >
>