How to display the records from database between the dates

Aug 22 2018 2:18 AM

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?

Answers (1)