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 <= @EndDate

3) 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