title: Get Current Date filtered query through ASP.NET web api
body: <p>In my program I need to filter Schedules which applicable to current month. I want json result bind with Jquery datatable. I created get method as follows</p>
  
  <pre><code> public IEnumerable&lt;ScheduleDto&gt; GetSchedules()
      {
          return _context.Schedules
  .Where(x =&gt; DbFunctions.TruncateTime(x.PlannedStartDate.Date) &gt;= DbFunctions.TruncateTime(System.DateTime.Now.Date))
                  .Include(d =&gt; d.ResponsibleDepartment)
                  .Include(e =&gt; e.EventCreatedBy)
                  .Include(c =&gt; c.ScheduleCategory)
                  .Include(y =&gt; y.ScheduleCriticality)
                  .Include(v =&gt; v.EventEvaluatedBy)
                  .Include(p=&gt;p.Participants)
              .ToList()
              .Select(Mapper.Map&lt;Schedule, ScheduleDto&gt;);
      }
  </code></pre>
  
  <p>Its response with following error message</p>
  
  <blockquote>
    <p>"The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported."</p>
  </blockquote>
  
  <p>I did several suggestion given by Stackoverflow members. But problem still as it is. 
  If anybody can find the error, I'm very much pleased. </p>