>I have a table where I need an index tag with the first character field in accending order and the second field which is a date in descending order. In VFP3 and VFP5 the following tag worked fine.
>
>INDEX ON location + STR({01/01/2020}-date_samp,8,0) tag location
>
>If I use this tag created by VFP5, VFP6 states that the index file does not match the table.
>
>If I re-create the tag in VFP6 it acts ok but the tag does not sort at all.
>
>Is this a bug?
>
>Is there a better way to do this anyway?
>
>Thanks,
David,
This may be related to teh SET STRICTDATE and the Y2K stuff that is in VFP6.
Try using this as the index expression;
INDEX ON location + STR({^20200101}-date_samp,8,0) tag location