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.
Asked
Active
Viewed 2,104 times
0
-
https://stackoverflow.com/questions/607817/get-dates-from-a-week-number-in-t-sql – Snowlockk Jun 12 '17 at 15:08
-
I don't want it to be in the SQL Query. – Jun 12 '17 at 15:30
1 Answers
1
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
niktrs
- 9,858
- 1
- 30
- 30