data parameters in matrix reports

• harita

  SSCrazy

  Points: 2197

  More actions

  October 20, 2010 at 10:29 am

  #388052

  Hi all,

  right now i am geting the data for a week from fridsy to friday (finished week)

  DateAdd(day, -6, Date) as WeekStartDate, Date as WeekEndDate

  now i want to get the date from 2 weeks (finished weeks) not the weeks comming up

  this is what i have in the quiry and i have the screen shot of the data parameters in on the matrix report.

  i dont know if i am asking the questing right but my requirement is 2 weeks data insteard of 1 week.

  thanks to all who got a change to look into it

• HakunaMatata

  SSCrazy

  Points: 2610

  More actions

  October 20, 2010 at 11:02 am

  #1239818

  I think this is what you are looking for -

  select (DATEADD(wk, DATEDIFF(wk, 6, getDate() - 15), 7))

  Just put the no of days old date you want in place of 15...

  :rolleyes: