How to use Between in query?

[eluser]Unknown[/eluser]
Hi

How to write select query with between similar to this with active record?

Code:

SELECT * FROM test_tbl WHERE date BETWEEN '$start' and '$end' ORDER BY ID

Regards