query for yesterdays data ?

[richardmorrison]

I need to be able to have SQL query a database for all yesterdays data - the date () -1 doesn't do it and the getdate () -1 either ?

I have seen some of the posts on here and know somebody must have come across this before ?

 

[Muttley]

Try using WHERE myDate < date() AND myDate > date()-2.

HTH

Muttley

 

[richardmorrison]

select movement_date from st_history where movement_date < date() AND movement_date > date()-2 and warehouse = 'C1'


Try using WHERE myDate < date() AND myDate > date()-2.


the top one is what i have just tried - do i have to define &quot;mydate&quot; ?? - I'm fairly new to SQL so be gentle !

 

[Cagliostro]

you should use
if datediff(dd,date(),mydate)<1 and datediff(dd,date(),mydate)>-1 John Fill

ivfmd@mail.md

 

[Muttley]

Sorry Richard, should have stated - I was using myDate as the placeholder for whatever date you wanted to test against date().

What you posted looks OK, but If you are not having any luck with my or JohnFills suggestion, I suggest that you try and build iteratively (i.e. first test that you have movement_date < date(), THEN that that you have movement_date > date()-2 etc. (If that isn't teaching you to suck eggs!).

Muttley