Also with the stored procedure did you try...

CREATE PROCEDURE xxx @date datetime AS

DECLARE @xdate datetime

SET @xdate = @date

SELECT yyy FROM zzz WHERE aaa = @xdate

I mentioned that as the last line of my post above but failed miserably at providing an example.