Retreive Yesterday's date

[aajaydee]

How to retreive yesterday's date
I have to build a report which gets every day data for yesterday date
I tried with datepart("d", getdate()-1) and it's not working
Any help will be greate

 

[gmmastros]

Select Convert(varchar(10), GetDate() - 1, 121)


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

where DateColumn >=DATEADD(dd, DATEDIFF(dd, 0, GETDATE())+0, -1)
and DateColumn < DATEADD(dd, DATEDIFF(dd, 0, GETDATE())+0, 0)

to test

SELECT DATEADD(dd, DATEDIFF(dd, 0, GETDATE())+0, -1), DATEADD(dd, DATEDIFF(dd, 0, GETDATE())+0, 0)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[gradley]

Try DateAdd(d,-1,GetDate())

If you need Date only with no time, try
DateAdd(d,-1,dateadd(dd, datediff(dd,0,GetDate()),0))

 

[aajaydee]

Thanks for your help