SSRS 2016 - Date Range Filter for “This Week”

Question

I am new to SSRS and Report Builder. I run SSRS 2016.

I have a report that is looking at a SharePoint list, the report pulls in the data fine but I need to filter a date field to only show dates from "this week" - as in:

I have a column called "Created Date" and I run the report at 5 pm on the last day of the week (Friday) - The report should only produce all of the items created within the last 5 days (Monday to Friday (including Today, Friday)

I know how to filter on items created today using the =Today() expression, but I have not been able to get anything to work for items created within the last working week.

Any help appreciated.

Thank you.

Answer 1

Personally, I would use 2 Parameters, say @DateFrom and @DateTo. Then you can filter your data to only include data where the Created Date is between @DateFrom and @DateTo.

If the report will always be run on a Friday, and you want Monday to Friday's data, then the expressions for your parameters would respectively be: =DateAdd("d", -5, Today() and =Today().