Zaraq,
How about:
INDEX ON ;
IIF(MONTH = "JAN",1,;
IIF(MONTH ="FEB",2,;
IIF(MONTH="MAR",3,;
IIF(MONTH="APR",4,;
IIF(MONTH="MAY",5,;
IIF(MONTH="JUN",6,;
IIF(MONTH="JUL",7,;
IIF(MONTH="AUG",8,;
IIF(MONTH="SEP",9,;
IIF(MONTH="OCT",10,;
IIF(MONTH="NOV",11,;
IIF(MONTH="DEC",12,0)))))))))))) TAG WHATEVER
HTH
Rex
>I have set a character field named Month with a regular index to store name of the months.When I use SET ORDER TO MONTH it indexes the field Month alphabetically as it is supposed to.How can I make it index on January , Feburary , March and so on instead of April, August, December etc....
>Thank You All
>Zaraq Bari
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement