Sort months

[manisha_uit]

Hi everyone,

Can anyone help me to sort months in a proper order.

Thanks

Manisha Choudhary

[Sokkorn · Accepted solution]

Hi Manisha,

Right Click on List Box --> Perperties --> Sort tab --> Check Expression --> Paste this code : =Match(MONTH, $(=chr(39) & Replace(MonthNames, ';', chr(39) & ',' & chr(39)) & chr(39)))

Hope this help you.

Note: MONTH is your month field.

Check attached file.

Regards,

Sokkorn

[manisha_uit]

Hi Sokkorn,

Thanks for your reply. Its working fine.

Thanks

Manisha

[its_anandrjs]

Hi,

It is depending on the load from where and what is the data type it is purely converted to original ones or not if it ls load from excel it shold be different.

See the attached sample one.

Reagrds,

Anand