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 : 684 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	Use the SQL server in Built Key word for that. SET DATEFIRST 7; Self-Innovator, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts