Answered by : portapipe

$minvalue = '2020-01-01 00:00:00';
$max_value = '2050-12-31 23:59:59';
$this->db->where("date_field BETWEEN '$minvalue' AND '$maxvalue'");

Source : https://stackoverflow.com/questions/9941521/using-between-in-where-condition | Last Update : Fri, 11 Sep 20