IN SSRS We can pass the last week Friday and current week Thursday dynamically as input parameter. You can also change the day of the week by changing the DATEADD value in the following query.
SELECT DATEADD(DAY, -3, DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()), 0)) SELECT DATEADD(DAY, 3, DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()), 0))
Passing dynamic date value based on day of the week to SSRS report. was last modified: October 1st, 2017 by