How to select data for particular date in linq using C#
<p>I am having List with data in the following format, </p>

<pre><code>TF000040070004-29/08/12
TF000040070004-29/08/12
TF000040070005-29/08/12
TF000020010004-29/08/12
TF000020010007-29/08/12
TF000020010002-29/08/12
TF000010010012-29/08/12
TF000010010014-29/08/12
TF000010010014-29/08/12
TF000010010005-29/08/12
TF000010010005-29/08/12
TF000010010006-29/08/12
TF000010010002-29/08/12
TF000010010008-29/08/12
TF000010010008-29/08/12
TF000010010008-29/08/12
TF000010010008-29/08/12
</code></pre>

<p>I used the following linq query to get count, key value and min and max. Now I want to select the data for particular date.</p>

<pre><code>var serialNumbers = from sn in code
                    group sn by sn.Substring(0, 10) into g
                    select new { Key = g.Key, 
                                 Cnt = g.Count(), 
                                 Min = g.Min(v =&gt; v.Substring(10)), 
                                 Max = g.Max(v =&gt; v.Substring(10)) };
</code></pre>
