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