priya Avanigadda

priya Avanigadda

  • NA
  • 45
  • 8.2k

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)