Sergey,

It should not depend on date anyway. I could not reproduce this odd behavior in my tests, so all I can suspect is some weirdness with data. May be you can look at them too?

>The best date to use would be date(9999,12,31).
>
>>>>BTW, you sent a file, which is part of database, so I need all triggers, etc.
>>>>
>>>>In the meantime just use another idex untill this problem will be resolved.
>>>
>>>Nadya,
>>>
>>>Thank you for looking at this. FYI in the zipfile I sent you, I had included the container files (DBC DCT DCX) for the database that the rates file belongs to.
>>>
>>>Laterness,
>>>Jon
>>
>>
>>Jon,
>>
>>You didn't send me triggers code, so when I tried to add a record or change it, I got bunch of errors. I modified the structure and got rid of triggers and default values, I delete index and re-added it, but I still could not find dates greater than 12/31/2000. This is odd!
>>
>>Perhaps, something is weird about your data. I've created a test at home, and everything works just fine:
>>

>>create cursor curTemp (BankCode C(6), ValDate D)
>>for i=1 to 500
>>    insert into curTemp values (substr(sys(2015),5), Date()+i*(-1)^mod(i,3))
>>next
>>index on bankcode+bintoc(date(2000,12,31)-ValDate)    tag test

>>
>>Did you receive the data from other source (e.g. they were not directly entered in VFP)? As I concluded, all dates after 12/31/2000 could not be find correctly. I don't know, what causes this behavior, because I can not reproduce it in my tests. All I can suggest for now, use another date, say, date(2010,12,31), so it will work.
>>
>>As I suggest: try to send the data to somebody else in addition, because 1 and 2 brains are good, but three+ is better :)