I was using the date parameter @StartDate and @EndDate , But SQL was executing from the year 19-- .
But how I can get values only between @StartDate and @EndDate .
*When i hid zero in SSRS in see only date between @StartDate and @EndDate without zero record.
Can anyone the way. Like if it in where clause dates between MM/DD/YYYY and MM/DD/YYY SSRS pick only value on the range.
Let me know your feedback.