Getting data posted in between two dates

Question

How can I retrieve data from the database by querying records between two dates using CodeIgniter's activerecord?

Answer 1

This looks like what you need:

$this->db->where('order_date >=', $first_date); $this->db->where('order_date <=', $second_date); return $this->db->get('orders'); 

Answer 2

Try This:

$this->db->where('sell_date BETWEEN "'. date('Y-m-d', strtotime($start_date)). '" and "'. date('Y-m-d', strtotime($end_date)).'"'); 

Hope this will work