title: How can I remove the Time from a DateTime value?
body: <p>In my SQL database, I have a column formatted as <code>DateTime</code> and when I retrieve data from that column in ASP.NET, I catch it on the Date variable, than pass the value to textbox:</p>
  
  <pre><code>Dim Y As Date = dt.Rows(0)("SCH_DATE")
  txtSchedDate.Text = Y.Date.ToString
  </code></pre>
  
  <p>but when I debug my website, the <code>txtSchedDate.Text</code> still gives me the full <code>DateTime</code> value:</p>
  
  <pre><code>7/17/2013 12:00:00 AM
  </code></pre>
  
  <p>is it possible to eliminate the time value here and just return the date?</p>