date between query in codeigniter

$this->db->where("DATE(your_date_column) BETWEEN 'start_date' AND 'end_date'");
$query = $this->db->get('your_table_name');
$result = $query->result();