Forecast Dashboard - Exclude results for Closed Days

// I believe that the query maybe based on some form of the query below (but I could be totally wrong about that :)

--Stores in zone, that did not get a forecast for a given date
--Get the stores that didn't import the Full Forecast - Today + 15 days
select distinct ez.entityid,e.Entity,e.Status from tbentityzone ez with(nolock)
join tbentity e with(nolock) on ez.entityid = e.entityid
where ez.ZoneID = 770
AND e.Status != 'Closed'
and e.TempCloseDate is Null
AND ez.EntityID not in (
	select EntityID from Forecasting.forecast with(nolock)
	where
	BusinessDay = CONVERT(VARCHAR(10), getdate()+15, 121)
	and GenerationDate > CONVERT(VARCHAR(10), getdate(), 121)
	--BusinessDay = '2020-06-29'
	)
--Get the stores that didn't import the Summary Forecast - Today + 20 days
select distinct ez.entityid,e.Entity,e.Status from tbentityzone ez with(nolock)
join tbentity e with(nolock) on ez.entityid = e.entityid
where ez.ZoneID = 770
AND e.Status != 'Closed'
and e.TempCloseDate is Null
AND ez.EntityID not in (
	select EntityID from Forecasting.forecast with(nolock)
	where
	BusinessDay = CONVERT(VARCHAR(10), getdate()+20, 121)
	and GenerationDate > CONVERT(VARCHAR(10), getdate(), 121)
	--BusinessDay = '2020-07-04'
	)