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
samratpbi
Super User
Super UserHi AliceTran1643 if you use date column in a slicer, then you should by default (style should be between) a date selection option appears. Please make sure your date column is in date format, i.e. data type is date.
If this helps to resolve your problem, then mark it as solution.
Thanks- Samrat