>I have a temporary table with user names and dates. User names are repeated with many dates for each user name. I need to print this table sorted by user name (ascending) with dates for each user (descending). I normally create another field and subtract the date fields from today's date to get a number that when sorted (ascending) will print the dates in descending order. Is there a simpler way to mix ascending and descending together?
with a string
INDEX ON UserName+bintoc({^9999/12/31}-userdate) ...