Jed

lets say i have 3 records in my table.. it looks like this

id order Podate
1 1 2010-03-10
2 2 2010-03-10
3 3 2010-03-11

and when i executed this query:
SELECT * FROM `tbl_id` WHERE PoDate Between ('2010-03-10') AND ('2010-03-11')

it only returns the result where the PoDate is 2010-03-10

how come it does not show the date with 2010-03-11?
can anyone help?