Getting data posted in between two dates

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');

php sql codeigniter activerecord

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

php sql codeigniter activerecord

This worked great for me

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

CodeHunter