Skip Ribbon Commands
Skip to main content

Erin Glenn's Blog

:

Erin Glenn's Blog > Posts > How to Get First Day of Last Week for Report Parameter SSRS 2008 R2
May 17
How to Get First Day of Last Week for Report Parameter SSRS 2008 R2

I needed to make a report parameter that would apply conditional formatting to my tablix based on a date range of the previous week start and end dates.

Start Date of Last Week:

=DateAdd("d",-7,(DateAdd("d",-DatePart(DateInterval.WeekDay,Today,0,0)+1,Today)))​

End Date of Last Week:

=DateAdd("d",-1,(DateAdd("d",-DatePart(DateInterval.WeekDay,Today,0,0)+1,Today)))​

Comments

There are no comments for this post.