title: MySQL Query with Idiorm and Date Issue
body: <p>I want to use a chart on some of my data and generate the values based on selected dates (with a date picker). I've stolen most of the stuff on the web and might have only a simple questions.</p>
  
  <p>Here is the Idiorm query:</p>
  
  <pre><code>if (isset($_GET['start']) AND isset($_GET['end'])) {
  
  $start = $_GET['start'];
  $end = $_GET['end'];
  $data = array();
  
  // Select the results with Idiorm
  $results = ORM::for_table('tbl_data')
          -&gt;where_gte('date', $start)
          -&gt;where_lte('date', $end)
          -&gt;order_by_desc('date')
          -&gt;find_array();
  
  
  // Build a new array with the data
  foreach ($results as $key =&gt; $value) {
      $data[$key]['label'] = $value['date'];
      $data[$key]['value'] = $value['rev'];
  }
  
  echo json_encode($data);
  }
  </code></pre>
  
  <p>The <code>$start</code> and <code>$end</code> are from my datepicker and in <code>yyyy-mm-dd</code> format. The only thing I don't know how to do is how to change the <code>-&gt;where_gte</code> statement. As you can see it's querying the db for the field <code>date</code>. In my db I have three fields, <code>year</code>, <code>month</code> and <code>day</code>. </p>
  
  <p>Is there a way to combing the three fields <code>year</code>, <code>month</code> and <code>day</code> into one expression i.e. maybe <code>-&gt;where_gte('year'&amp;'month'&amp;'day', $start)</code>???</p>
  
  <p>I tried searching and searching but maybe have the wrong keywords or to less knowledge.</p>
  
  <p>Thanks in advance for any help!</p>