I am workign on a SSRS report. I created a report which gets the records between two date ranges. This report has 2 date parameters. The report is running with out any errors but for some reason even i use date range the data is not filtered. I mean i am tryin to see the data between 1st of this month to current date. The results are showing records before the startdate parameters. That mean the filter is not working. But still it does not give any error.
Please see the code below
select * from ABC
where date between @StartDate and @EndDate