>Hi All,
>
>I would like to index on a character field, name_horse c (18), and a date field "serv_date.
>
>The name_horse field should alphabatize a to z and then the serv_date field from the most current date to the oldest.
>
>Amber Hanover 02/10/2003
>Amber Hanover 02/09/2003
>Amber Hanover 01/23/2003
>Amber Hanover 12/21/2002
>Babs 02/09/2003
>Babs 02/02/2003
>Babs 10/23/2002
>Corinne Lobell 02/08/2003
>Corinne Lobell 02/02/2003
>Corinne Lobell 01/10/2003
>
>This index alpha's the name okay, but the dates are oldest to newest
>name+DTOS(date_serv)
>
>If I declare the index when I open the table as:
>"use healthvet order name_horse desc"
>The dates are descending, but the names start with the "Z's".
>
>This gives me an error message.
>name+desc(DTOS(date_serv))
>
>Is there a way to mix field types and have one ascending and the other descending?
>
>TIA
>Jim Harvey
>jharvey@hanoverpa.com

Try:

Index On name + DTOS( {^9999/12/31}-date_serv)