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.