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
Super UserIf by query designer, you mean power query/query editor you should still be able to create transformations that suit your need although I am unsure what you really want to achieve. And as what other users have already mentioned, if you're trying to choose a date range, why not just use the date slicer? Otherwise, please provide more context to your post, a sample data and your expected result from the same.