I get an error at the following lines:

SELECT @startdate = ( SELECT DATEADD( 'day', -1 @startdate ))
SELECT @enddate = ( SELECT DATEADD( 'day', 1, @enddate ))

Tells me that I have an invalid parameter for dateadd for both lines.

-Jack