Retrieving data between two dates in codeIngiter

To get the data between two dates in CodeIgniter, you can use the BETWEEN Operator. The BETWEEN operator selects values within a given range. The values can be numbers, text, or dates. More

$this->db->query("SELECT * FROM TABLE WHERE date BETWEEN '$startDate' AND '$endDate'");