Date Value Problem

[eluser]rafi_ccj[/eluser]

Code:

$this->db->where('table.column1 >=', $date1);
$this->db->where('table.column1 <=', $date2);

this is my code to get some data within a date range..... but this is not working always...


how do i get data according to a date range?

[eluser]Aken[/eluser]
What format are your date columns in? What format are $date1 and $date2 in?

[eluser]rafi_ccj[/eluser]
both are in dd-mm-YY format.