>>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 :)