Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

data parameters in matrix reports Expand / Collapse
Author
Message
Posted Wednesday, October 20, 2010 10:29 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, March 17, 2014 2:54 PM
Points: 95, Visits: 188
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


  Post Attachments 
1.jpg (2 views, 68.96 KB)
Post #1007872
Posted Wednesday, October 20, 2010 11:02 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, August 11, 2014 8:55 PM
Points: 918, Visits: 491
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...


Post #1007891
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse