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?
kupy
SSCommitted
Points: 1652
More actions
October 23, 2012 at 9:08 am
#1551966
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