Sort Month Name

[#1]

Hi,

I have a question. I have load a calendar data successfully. When I want to show Month Field using list box, the first data is Dec not Jan. I have two field to be used in sort column, MonthNum (1-12) and MonthName (Jan-Dec). Anybody knows the method to sort month name correctly ?

Really appreciate your help, thanks

[jagan]

I mean you have to give this expression in all the month list boxes.

Regards,

Jagan.

[#3]

Oh I see Jagan,

So do you have another suggestion or method ?

Thanks Jagan

[#4]

If you use just MonthNum in the sort -> Expression, when you select one month, MonthNum will become 'Null' for not selected months. This causes them to appear first. To avoid this, irrespective of month selections, Only({1}MonthNum) always returns the corresponding number.

And as suggested earlier, to avoid this work around, always use date functions to create master calendar.

Regards,

KKR