Working with CURRENT_TIMESTAMP

[eluser]CroNiX[/eluser]
I'm guessing that you don't actually have a date in your database that is between those particular dates (2012-08-29 AND 2012-09-05) in the date_created field. Have you verified that you do?

You're returning all dates greater than your end date in the query returning results.

Code:

$this->db->where('date_created >=', $startDate);
$this->db->where('date_created <=', $endDate);

would be the same thing as the between statement.