Sort Moth

[migueldelval]

Hi all,

I have this Dimmension:

=IF( FLAG_LAST_WEEK_MONTH='1', left(MONTH_NUMBER,3)&'-'&(YEAR_NUMBER) ).

But my months aren´t sorted, they are like Picture.

And I need to sort them, in normal order.

Could some body help me?

Regards

Miguel del Valle

[migueldelval]

Hi Rudolph,

Thanks, But your expression it don´t make anything.

Regards

Miguel del Valle

[sunny_talwar · Accepted solution]

Can you check the environmental variable in the script? See if you have this?

SET MonthNames='Ene;Feb;Mar;Abr;May;Jun;Jul;Ago;Sep;Oct;Nov;Dic';

[SunilChauhan]

are you getting  MonthNUm and YearNum from  Date field, then you Can use below in Expression

Date(MonthName(Date),'MMM-YYYY')

[migueldelval]

Hi Sunny T,

This it was the problem,I have made change in SET MONTHNAME, and everything it´s correct.

Thank you very much.

I was starting to drive me crazy.

Regards

Miguel del Valle

[sunny_talwar]

Awesome, I am glad you were able to figure this out

Best,

Sunny

[migueldelval]

Hi Sumil,

Thank you, but it´s better to my qvw Sunny´s answer.

Regards

Miguel del Valle