How to fix sequence of months in LIST BOX?

[#1]

Basically, I want to fix sequence according to financial months

1. I tried it using wildmatch,match

2.Also, tried with if else condition.

But nothing is working.Please suggest me.

[Anonymous · Accepted solution]

sort by expression:

FINALMONTHFIELD

or perhaps:

min(FINALMONTHFIELD)

[#3]

Thanks Robin.

[Anonymous]

if my answer is correct, then please mark it as correct.

[passionate]

Hi Shubham,

There are various ways you can achieve this:

Put below in sort by expression.

Pick(Match(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'),1,2,3,4,5,6,7,8,9,10,11,12)

Set the arrangement to Ascending

note: you can also change the sequence of Jan,Feb,Mar,etc by changing the sequence in Match function.

Regards,

Pankaj

[#6]

Thanks Robin.It's working.

[#7]

No Pankaj.That's not working.Actually, I already tried it.

Thanks.

[passionate]

Hi Shubham,

It might be your month name is not matching.

To check that put below expression in list box and see if you get a list of values ranging from 1-12.

Match(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

Regards,

Pankaj