Como usar o comando BETWEEN no Mysql:
SELECT * FROM Tabela
WHERE Campo = 1
AND CampoDataOuHota
BETWEEN ‘ 09/10/2012’ AND ‘ 10/10/2012’
Como usar o comando BETWEEN no Mysql:
SELECT * FROM Tabela
WHERE Campo = 1
AND CampoDataOuHota
BETWEEN ‘ 09/10/2012’ AND ‘ 10/10/2012’