Try this:
SELECT <ListOfColumns>
FROM TableName
WHERE DateField BETWEEN '2016-08-28' AND '2016-08-29'
or
SELECT <ListOfColumns>
FROM TableName
WHERE DateField IN ('2016-08-28', '2016-08-29')
or
SELECT <ListOfColumns>
FROM TableName
WHERE DateField >= '2016-08-28' AND DateField <='2016-08-29'