Forum Discussion
Solved
How to set Date Parameters to show data between 2 dates selected from 1 date column
Hello, I wanted to set up a parameter for users to select a date range and generate a report showing data in between the selected dates. I have looked up videos/previous posts about this and all su...
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
Mauro89
Super User
Super UserHi AliceTran1643,
what about just using the slicer visual, put in your date column and set the option to "between"? Then the user can select the start and end date directly on the slicer.
Best regards!
PS: if this helps, leave kudos and mark it as solution.