In command window I wrote

set date british
use dep
index on acno to lnAcnot
lnAmount=95
mdate=ctod("10/10/2005")
mdate1=ctod("31/03/2006")
brow for balance<lnBalance and date>=mdate and date<=mdate1

No result.

But if I write

brow for balance<lnBalance

I am getting the balance which is less than lnBalance