Hi,
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