When you call the stored procedure you do not have to include time portion.

exec uspReportData '2004-03-01', '2004-03-15'

is same as

exec uspReportData '2004-03-01 12:00:00', '2004-03-15 12:00:00'