How to set Sunday as First and Saturday as Last Day of the Week

Posted by Self-Innovator under Sql Server on 7/17/2014 | Points: 10 | Views : 1047 | Status : [Member] | Replies : 1
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 Sunday
="[TIME].[Weeks].[Day ID].[" + format(DateAdd(DateInterval.Day, 1-WeekDay(Today), Today),"d MMMM yyyy") + "]"

Any soln...?

Join Hands Change lives
Thanks & Regards
Straight Edge Society


Posted by: Lakhangarg on: 7/22/2014 [Member] [Moderator] Silver | Points: 25

Use the SQL server in Built Key word for that.

Self-Innovator, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response