title: Enumerable.Range to pull months back dynamically
body: <p>I'm working on an MVC framework report where we are trying to restrict the users to two years of data (from today's date).  Per their requirements, we have a month and year dropDownList and the users are only supposed to see two years of data.  So, at present, if they chose 2013, they would only see the months of November and December.</p>
  
  <p>Got the year DDL populated, now I'm trying to get the month list populated based on what year was selected.</p>
  
  <p>Here's what gets me all of the months:</p>
  
  <pre><code>var months = Enumerable.Range(1, DateTime.Today.Month)
      .Select(x =&gt; new SelectListItem { Text = x.ToString(), Value = x.ToString() });
  
  return new SelectList(months.ToList(), "Value", "Text");
  </code></pre>
  
  <p>New to these queries but feel like there has to be a way to do this within the query itself.  </p>
  
  <p>Thanks in advance!</p>