Home Forums SQL Server 2008 T-SQL (SS2K8) Why does my yesterday query return no results? RE: Why does my yesterday query return no results?

  • October 23, 2012 at 7:32 am

    #1551898

    SELECT *from SLADB.dbo.DocketTB

    where Docket_EngFinish >=dateadd(d,datediff(d,0, getdate()),-1) AND Docket_EngFinish<dateadd(d,datediff(d,0, getdate()),0)

    This works, is there a better way ?

    Thanks again Chris 🙂