Set Default Parameters for Previous Month
Posted on 2010-08-13
On the beginning of every month, I intend to run a report for the previous month. I want to keep the default format YYYYMMDD. So for example, if I ran the report on August I would lke SSRS to default my @startDate and @EndDate as the previous month, but don 't know the syntax to find last day of month for @EndDate
@StartDate = Format(dateadd("M", -1, today()), "yyyyMM")+"01"
@EndDate = 20100731