title: SQL where clause that would select specific daterange based on NOW()
body: <p>I'm having trouble putting together a where clause that would select records based on a column called DatePick based on now().</p>
  
  <p>Basically, what I need is a where clause that would result in the following:</p>
  
  <p>NOW() = today (8/16/11), then breaks up the year based on 1/3 so this example is 3)<br>
  1/1/11-4/15/11:1<br>
  4/16/11-8/15/11:2<br>
  8/16/11 - 12/31/11:3  </p>
  
  <p>And another example if now() = 1/1/12 then the result would be 1<br>
  1/1/12-4/15/12:1<br>
  4/16/12-8/15/12:2<br>
  8/16/12 - 12/31/12:3  </p>
  
  <p>Then based on that date range (1 or 2 or 3) it would select all records in DatePick for that daterange.  I would love this to be dynamic based on year</p>