Dear Shi Jinghai, your solution is exactly what we already did to resolve this problem. We just created a helper method which built up this "between-like structure". It has been working fine for several months.
The reason I wrote to the ML, is that if EntityCondition.BETWEEN does not actually work, we should remove or correct it. Not just have a workaround!! Can any of the OFBiz core team shed some light on this? cameron ___________________________________________________________ Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for your free account today http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter07.html