Create procedure superPuper (@dateParam datetime)
  myUDF(@dateParam);
  ...
  select field1, field2
  from table
  where @dateParam ...
End

exec superPuper @dateParam