CODEWITHSUNDEEP
ssrs-2008-r2
Arsee
Arsee

Reputation: 671

SSRS Date Parameter Default

I have a report that I need to set-up a default date for @Star and @End date parameter to Last Sunday for @Start and Last Saturday for @End. Found the code to Last Day of previous week (Sunday) =DateAdd(DateInterval.Day, -0,DateAdd(DateInterval.Day, 1-Weekday(today),Today)), but unable to find expression for the Saturday. I tried to modify the (Monday) =DateAdd(DateInterval.Day, -6,DateAdd(DateInterval.Day, 1-Weekday(today),Today)), but giving a different result.

Upvotes: 0

Views: 272

Answers (1)

SuperSimmer 44
SuperSimmer 44

Reputation: 999

Expression for last saturday

=DateAdd(DateInterval.Day, -1,DateAdd(DateInterval.Day, 1-Weekday(today),Today))

Upvotes: 1

Related Questions