CODEWITHSUNDEEP
reporting-servicesssrs-2012
user7841988
user7841988

Reputation:

How to get the Start Date of the Week, if I have the Week number of the year in SSRS Report Builder 3.0?

I used the following expression to get the week number of the year:

=DATEPART("ww", Fields!Date.Value)

How to get the start date of that week number in SSRS Report.I have this in my report

And I want it to achieve this.

Upvotes: 0

Views: 2495

Answers (1)

niktrs
niktrs

Reputation: 10066

Your expression should look like this:

= DATEADD("d", - DATEPART(DateInterval.Weekday,Fields!Date.Value) +1,Fields!Date.Value)

Explanation: From the date field, subtract the day of week number to get the first date of week

Upvotes: 1

Related Questions