Date Filter help required

[hpesojrevilo]

Hi,

I want to be able to filter by date looking back 6 months. I then want to include data from 12 months, 18 months, 24 months etc

How would i do this without having to repeat myself? Currently i am using the below and then repeating it

 

e.g

between dateadd(dd,-189,getdate()) and dateadd(dd,-183,getdate())

between dateadd(dd,-373,getdate()) and dateadd(dd,-366,getdate())

 

Thanks in Advance,

[justsomeguy]

SQL doesn't have a way to say "group by every 6 months", you just have to explicitly tell it what you want.