Query to retrieve yesterday's date and 4 weeks of that same day 1

[henchcliffe]

Hi,
I am trying to write a query that will retrieve yesterday's date (date()-1) plus the past 4 weeks of that same day.

So if today is wednesday the query will retrieve yesterday (tuesday) and the past 5 tuesdays.

Any ideas?

THANKS!

 

[r937]

select somecolumns
  from sometable
 where somedatecolumn in
       ( date()-1
       , date()-8
       , date()-15
       , date()-22
       , date()-29 )

rudy

http://rudy.ca/

 

[r937]

ooooops

that should have said

where date()-somedatecolumn
in (1,8,15,22,29){/b]

sorry

 

[r937]

where date()-somedatecolumn
in (1,8,15,22,29)

sorry

 

[henchcliffe]

Excellent!
I cant believe I didnt think of this before. I was trying to do something with "DateAdd" but this is much simplier.

THANKS!!