Thank you for all your inputs the following is my final statement that solved my problem following ScottPletcher

SELECT *
FROM hospital_cases
WHERE ((date_admitted <= @EndDate) AND (date_discharge >= @StartDate))...

Found partial solution https://www.sqlservercentral.com/forums/topic/check-if-date-ranges-overlap. This solve if the DateDischarge is not NULL.