opencart/opencart — pull request #1259 by Noloony (2014-03-13 13:50:40+00:00)
Title: V1.5.6.1 admin/model/sale/order Sort by Date Modified

There is faulty SQL in the admin ModelSaleOrder this prevents you from filtering orders by DateModified

admin/model/sale/order.php:623

Faulty code
if (!empty($data['filter_date_modified'])) {
$sql .= " AND DATE(o.date_modified) = DATE('" . $this->db->escape($data['filter_date_modified']) . "')";
}

The code should be
if (!empty($data['filter_date_modified'])) {
$sql .= " AND DATE(date_modified) = DATE('" . $this->db->escape($data['filter_date_modified']) . "')";
}