I'm trying to query a database with a between 2 dates... The problem is the column that I am querying contains dates that are currently formatted like this "01/01/2014" (dd/mm/yyyy) with a column type of VARCHAR.

At the moment, I can't convert the column to a date type.

Basically when I query the table because it's not set to date type the between query doesn't return the correct rows...

Has anyone else come across this problem, is there something I can change within the query?

$this->db->where('IssueDate >=', '02/12/2013');
$this->db->where('IssueDate <=', '22/01/2014');
$query = $this->db->get('MYTABLE');

Thanks guys.