I can't see anything wrong with what you are trying. Are you sure that you have records which meet the criteria? Try

SELECT * FROM dep WHERE balance < lnBalance ORDER BY date

and manually inspect the result to see if there are any records in your date range.

It "shouldn't" be causing a problem but you don't need to use CTOD(). You can create date values directly using curly braces. To avoid possible problems with SET DATE use StrictDate notation.

USE dep
INDEX ON acno TO lnAcnot
lnAmount = 95
mdate = {^2005-10-10}
mdate1 = {^2006-03-31}
BROW FOR balance < lnBalance AND BETWEEN(date,mdate,mdate1)

Again, from what I see, I think the "problem" is that there are no matching records in your time frame. I don't see my strictdate suggestion making a difference but, as mentioned in another part of the thread, "it can't hurt."


>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