>> indices based on 12/31/99-DateField to sort in reverse-date order...
>
>... should continue to work fine..., as long as they didn't apply STR() to the expression. If it remained numeric, it's still OK.
You're right, I picked a bad example.
There was another program I came across where (after DTOS() was available, I'm pretty sure), the programmer made an index on SUBSTR( DTOC(), ...) such that they ended up with YYMMDD on purpose. Obviously NOT Y2K compliant. (There was so much wrong with that program ... but I was only allowed to change things which were specifically Y2K bugs.) Maybe they made that index before DTOS was available. The program was written in FP1.02 if not FoxBase. (I think DTOS was in 1.02, but not FoxBase, right?) They used idx files, it was pre-CDX. Of course they also only opened each index when they needed it, and did a reindex command every time they changed index so it'd be up to date... That program was a joy to behold!
>Right. I've caught myself swatting my right hand with my left every time I invented something based on dates, that could break before I retire :)
I've never made a mistake, personally, so I never had reason to swat myself!
>Translated from Latin scroll dated 2BC
>Dear Cassius:
>[snip]
>Plutonius
ROTF!
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing