That works but am struggling to apply that to my query
select * from dbo.DocketTB where Docket_EngFinish DATEADD( hh, 7, DATEADD( dd, DATEDIFF( dd, 0, DATEADD(dd, -7, getdate())), 0)),
DATEADD( hh, 7, DATEADD( dd, DATEDIFF( dd, 0, getdate()), 0))
how do I add the where Docket_EngFinish column
Jay