Click here to Skip to main content
15,123,118 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SSRS Reportinf Expressions
How can i set First Date of the Week as Sunday And Last Date of the week as Saturday.

In my Below Expression i got to have Monday as first day of the Week and Mondayas last week
First Date of the Week It gaves me 6th July 2014 Monday

="[TIME].[Weeks].[Day ID].["+ format(DateAdd(DateInterval.Day, 1-WeekDay(Today), DateAdd(DateInterval.Day, -7, Today)),"d MMMM yyyy") + "]"

Last Date of the Week It gaves me 13th July 2014 Monday instead i need 12 July 2014 Saturday

="[TIME].[Weeks].[Day ID].[" + format(DateAdd(DateInterval.Day, 1-WeekDay(Today), Today),"d MMMM yyyy") + "]"
Updated 17-Jul-14 8:07am

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900