MYSQL小于功能不能正常工作

I need to get all records those equal and less than 2014-08-31 and greater than 2014-08-01 i used bellow query for this, does anyone has idea ?I need to get all records those equal and less