I think you can use the following sql to do your work

select * from My_Table

where col_date between isnull(@Start_Date, '1900-01-01') and isnull(@End_Date, '2999-01-01')

Assume your real date is no earlier than '1900-01-01' and no later than '2999-01-01')