title: How to make a query linq check date is in month, quarter or a year
body: <p>I have a User table with <code>userdateregistered</code> field, and want to show User registered in the current month, last month, current quarter, last quarte, current year and last year (date reference is datetime.now).I need to build a linq query</p>
  
  <p>For example:</p>
  
  <p>2013/12/31  if is in the month December(12)</p>
  
  <p>2012/01/15 if is in the first quarter (1)</p>
  
  <p>2013/05/12 if is in the year 2012.</p>