title: Linq - Select Date from DateTime
body: <p>I have a <code>Linq</code> Result from which I need to select only <code>Date</code> from <code>DateTime</code>.<br>
  My Query goes like this :  </p>
  
  <pre><code>var UserTemplates = (from xx in VDC.SURVEY_TEMPLATE
                       where xx.USER_ID == userid &amp;&amp; xx.IS_ACTIVE == 1
                       select new
                       {
                         xx.TEMPLATE_ID,
                         xx.TEMPLATE_NAME,
                         //CREATED_DATE = xx.CREATED_DATE.Value.Date
                         //CREATED_DATE = EntityFunctions.TruncateTime(xx.CREATED_DATE)
                         xx.CREATED_DATE
                       }).ToList();
  </code></pre>
  
  <p>Is that Possible?
  Any help would be greatly appreciated.</p>
  
  <pre><code>CREATED_DATE - `datetime` datatype
  </code></pre>
  
  <p>Actually,I'm Binding it to a Control as a <code>DataSource</code> and the control is displaying both <code>Date and Time</code>.But I want to display only <code>date</code>.</p>
  
  <p>When I'm trying with <code>CREATED_DATE = xx.CREATED_DATE.Value.Date</code>,It is giving an error like :</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>