Hi I would like to create a stored procedure that accepts the current date as a parameter. something like: create procedure proc_name @rundate datetime = getdate as . . . . go and then run it with execute proc_name However, doing it this way I get 'syntax error converting datetime from character string. Can anyone help / point me in the right direction please. PS If I don't specify a default, and then put the parameter at the end of the execute statement as below it works fine, but this kind of defeats the object of automating the procedure in the first place! create procedure proc_name @rundate datetime as . . . . go execute proc_name '2005-12-20'