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,