title: Simple LINQ Select Statement
body: <p>I'm having basic difficulties with LINQ select statement.</p>
  
  <p>What I want is quite simple : I have an ID. I use that ID to get certain value from the table. It does work, but with a twist...</p>
  
  <p>Here is the code:</p>
  
  <pre><code>var myDate = dbContext.tbl_mytable.Where(i =&gt; i.myID == item.myID)
                            .Select(i =&gt; new {Name = i.KeySourceDate});
  </code></pre>
  
  <p>I was expecting a <code>DateTime</code> in myDate. Image shows what I got instead.</p>
  
  <p><a href="https://i.stack.imgur.com/vLd1k.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vLd1k.png" alt="enter image description here"></a></p>
  
  <p>I understand the final value of name = thedate, since it's in the select statement.</p>
  
  <p>What I need at the end is JUST a date formatted like this .ToString("dd/MM/yyyy"), and not the whole object, or whatever comes from the LINQ.</p>