Monthly Report in Report Builder 3.0
I am creating a report in report builder 3.0. I would like this report to pull its data from just the previous month's data. I need help with how to build the expression for this.
ThanksRob Nunley
May 6th, 2011 1:31pm
Hi Rob,
You may use ADDDATE sql server function. Please see an example below.
select DATEADD(m, -1, GetDate()) as TodayMonthAgo
Remember to mark as an answer if this post has helped you.
Free Windows Admin Tool Kit Click here and download it now
May 6th, 2011 4:25pm