select * from tb
where stuff(date,1,1,'') between right(convert(varchar(8),dateadd(day,-4,getdate()),112),4) and
right(convert(varchar(8),getdate(),112),4)
select * from tab
where stuff(date,1,1,'') between right(convert(varchar(8),getdate(),112),4) and
right(convert(varchar(8),dateadd(day,5,getdate()),112),4)