Forum Discussion
How to set Date Parameters to show data between 2 dates selected from 1 date column
1) Create two parameters
@StartDate (Date/Time)
@EndDate (Date/Time)
Set:
Data type = Date/Time
Allow null = No (or give defaults)
2) Filter the dataset on the single date column
Your dataset already has EntryDate — that’s enough.
In the dataset query filter (or WHERE clause equivalent):
WHERE EntryDate >= @StartDate AND EntryDate <= @EndDate3) If using the Dataset Filters (no SQL)
If your SharePoint List dataset doesn’t expose SQL:
Open Dataset Properties
Go to Filters
Add:
Expression: =Fields!EntryDate.Value
Operator: >=
Value: =Parameters!StartDate.Value
Add another filter:
Operator: <=
Value: =Parameters!EndDate.Value
Hi AliceTran1643 , Thank you for reaching out to the Microsoft Community Forum.
Thank you danextian cengizhanarslan praveen_511 Murtaza_Ghafoor for your valuable responses.
All users answered correctly but now since you stated that this is a paginated report created in Report Builder, the correct way to let users select a date range is by using report parameters. Paginated reports do not support slicers or interactive filtering after the data is loaded, so filtering must happen when the dataset runs.
You only need your existing Entry Date column from the SharePoint List. Create two report parameters, a Start Date and an End Date and apply them as filters on the dataset so that Entry Date is greater than or equal to the start date and less than or equal to the end date.
When the report is run, users will be prompted to enter the date range and the dataset will return only the records where Entry Date falls within that range. This is the standard and supported pattern for date range filtering in paginated reports using SharePoint data.
Thanks.
Thank you for reaching out to the Microsoft Fabric Forum Community.
I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.