Query Builder:: Between

Hi guys,

how to write the sql statement in query builder::between??

SELECT * FROM sale WHERE DATE(local_created)BETWEEN '2011-10-01' AND '2011-10-07'


->select ('*')

->from sale

->where(array("date(local_created) between", array('2011-10-01', '2011-10-07'))

I think there is not a simple way to do it

for example you can see how hard it is to increment counter via query builder


so here you also have the same issue… if it is not built in - use DAO

but maybe I wrong…