Home Forums Reporting Services Reporting Services data parameters in matrix reports RE: data parameters in matrix reports
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: