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,