• 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