Multi Box Sorting problem

[#1]

I have a situation when I need many different calendars, Like GMT, EST, User specific TZ.

For each of the calendars' fields there are a prefixes like "GMT_", "EST_".

There is a prefix field in the system like:

PrefixTable:
load * inline [
TZPrefixName,TZPrefix
GMT,GMT_
EST,EST_
Session TZ,Session_
Station TZ,Station_
];

There are variables for current calendar fields presentation, like:

SET vCurrTZPrefix=TZPrefix;

SET vDateTime = "=$(vCurrTZPrefix) & 'DateTime'";
SET vDMDate = "=$(vCurrTZPrefix) & 'DMDate'";
SET vDMYear = "=$(vCurrTZPrefix) & 'DMYear'";
SET vDMMonth = "=$(vCurrTZPrefix) & 'DMMonth'";
SET vDMWeekDay = "=$(vCurrTZPrefix) & 'DMWeekDay'";
SET vDMDay = "=$(vCurrTZPrefix) & 'DMDay'";
SET vDMHour = "=$(vCurrTZPrefix) & 'DMHour'";
SET vDMMinute = "=$(vCurrTZPrefix) & 'DMMinute'";
SET vHourCount = "=$(vCurrTZPrefix) & 'HourCount'";
SET vStartDT = "=$(vCurrTZPrefix) & 'StartDate'";
SET vEndDT = "=$(vCurrTZPrefix) & 'EndDate'";

In a dashboard, there is a Multi Box with the expressions instead of real fields. Everything works fine. There is one problem only - sorting of values in the multi box expression based fields. Instead of expected sequence for week days: Mon, Tue, Wed, Thu, Fri, Sat, Sun; I have got: Wed,Thu,Fri,Sat,Sun, Mon,Tue. There is same problem with a month days.

To understand what I'm talking about just take a look at my attached example, where I've made an emulator of the situation.

Is there any idea how to deal with the sorting, or may be there is another solution for whole approach?

QV version is 9.00.7440.8 SR3 x64

[johnw]

Nick Bor wrote:Wait a second. Where are the months' names?

Oops. I needed to treat months like I treated weekdays in order to get the month names:

CONCATENATE ([Sort Orders])
LOAD month(addmonths(date#(20091201,'YYYYMMDD'),recno())) as DMMonth
AUTOGENERATE 12

[#3]