title: Datetime function: semester, quarter
body: <p>I am using these formulas on a select query, based on the [Date] field. Semester is 1 for Jan-Jun, 2 for Jul-Dec. Quarter is the 3-month version (1 for Jan-Mar etc).</p>
  
  <pre><code>case when Month([Date])&gt;=7 then 2 else 1 end as [Semester],
  ceiling((Month([Date])-1)/3)+1 as [Quarter]
  </code></pre>
  
  <p>These work, but I am wondering if there is a simpler/more elegant solution (although I've checked the datetime functions out).</p>
  
  <p>It seems strange to me that a language with an ntile() function would not have something similar for dates. </p>