Ireport report showing up without data

Question

I am making a report with Ireport and passing a parameter with date range my sql in the report SELECT * FROM venda WHERE data between (venda.data = $P{dataInicial}) AND (venda.data = $P{dataFinal})

However, when testing the report in preview, I select the interval date at the prompt and come the screen did..

Does anyone have any idea ?

Answer 1

Or use:

SELECT * FROM venda WHERE data between $P{dataInicial} AND $P{dataFinal};

or use:

SELECT * FROM venda WHERE venda.data >= $P{dataInicial} AND venda.data <= $P{dataFinal};