Here is the code that I using.
AND (@Parm_Year = DATEPART(YYYY, field))
Using this allows me to pick one year at a time only not multiple years.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answer by Jon Crawford · May 29, 2020 at 12:46 PM
set the parameter to allow multiple results, use AND DATEPART(YYYY,field) IN (@Parm_Year)
Answers Answers and Comments
21 People are following this question.
SSRS Expression Multiple Like Parameter
ReportBuilder 3 - Update a Parameter with an Action
Problem in retrieving records - Retrieve records with date parameter
Creating A Multi Value LIKE Expression in SSRS
Optional Parameters with range