• Hi

    Did you try DATEDIFF(day, Docket_EngFinish , getdate())=1 ?

    The datediff by day checks only the day part and not the time.

    http://msdn.microsoft.com/en-us/library/ms189794.aspx