title: Change date Format or String length of lable ItemTemplate
body: <p>Is there a way to format the text I get from my dataset (which is a date type) to not show time.</p>
  
  <p>I had it in my sql query to format the date to not show time, but then I had to change it into a string and I need the datatype to still be a Date. </p>
  
  <p>So I cant user This any more...</p>
  
  <blockquote>
    <p>CONVERT(varchar(15),em.endDate,111) as endDate  -->  2001/05/05</p>
  </blockquote>
  
  <p>And this doesn't work</p>
  
  <blockquote>
    <p>CONVERT(Date,em.endDate,111)   --> Output : Output : 5/5/2001 12:00:00 AM</p>
  </blockquote>
  
  <p>Here is my Template.</p>
  
  <pre><code> &lt;asp:TemplateField HeaderText="endDate" SortExpression="endDate"&gt;
       &lt;ItemTemplate&gt;
           &lt;asp:Label ID="lblEndDate" runat="server" Text='&lt;%# Bind("endDate") %&gt;'&gt;&lt;/asp:Label&gt;
       &lt;/ItemTemplate&gt;
   &lt;/asp:TemplateField&gt;
  </code></pre>
  
  <p>Is there a way to maybe modify the template to cut out the Time of the date?</p>