>>I am maintaining a legacy system for VFP 5.0. There are tables in the system that store dates as character (8). Why they did this is beyond me, but there is nothing I can do right now.
>>
>>What I did was put in a ROLLOVER function:
>>SET CENTURY TO 19 ROLLOVER 60
>>
>>This works, except there is an index on one of the tables that looks something like:
>>SET INDEX TO DTOS(DTOC(PURDATE))+VENDNO+INVNO TAG INVOICE
>>
>>Doing a seek fails because the index can't seem to deal with the ROLLOVER. (It just rolls over and plays dead.) No error is produced, the seek value is simply not found. I have verified that the data is in the file. It just seems that the rushmore technology fails in this situation.
>
>Are you sure you got this index expression right?
>
>DTOS(DTOC(PURDATE)) should give an error under any circumstances.

I meant CTOD instead of DTOC. (I must be brain dead) At any rate, the index expression is written correctly. This all worked fine before Y2K. After the rollover kicked in, it started playing dead.