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