Jump to content

hpesojrevilo

Members
  • Posts

    1
  • Joined

  • Last visited

hpesojrevilo's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. 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,
×
×
  • Create New...