Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index on Month
Message
From
17/08/1998 07:26:49
Rex Mahel
Realm Software, Llc
Ohio, United States
 
 
To
14/08/1998 16:15:39
Zaraq Bari
Bari Studios Limited
Lahore, Pakistan
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00127022
Message ID:
00127338
Views:
32
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform