Hi ,
I want to display the records between FromDate and ToDate
Ex: 1/08/2018 to 22/08/2018 =>it should display records between these two dates
I wrote a query to get the records from database between dates like below,
_queryPredicate = _queryPredicate.Or(c =>
c.CreatedOn >= PivotRequest.PeriodFromDate && c.CreatedOn <= PivotRequest.PeriodToDate);
but this is giving total records can anyone tell me , what was the mistake am doing?