title: Getting data between two date range in codeigniter
body: <p>I'm trying to fetch data between dates. The date select from date-picker. the formate is like this 04/13/2020 - 04/13/2020 select from date-picker. my query is like this</p>
  
  <pre><code> public function reservation($reservation)
      {
      $this-&gt;db-&gt;select("*");
      $this-&gt;db-&gt;from('details');
      $this-&gt;db-&gt;where("DATE_FORMAT(date,'%Y-%m-%d') &gt; '$reservation'");
  
          $query = $this-&gt;db-&gt;get();
          return $query-&gt;result();
      } 
  </code></pre>