Month disordering !!

[nikhilgarg]

HEy,

I have used Month field and used a list box but my months are not coming in Jan-Dec order. They are coming in A-Z order.

What to do , please help.

Thanks

[sasikanth · Accepted solution]

plese check the spelling of 'july'
filed values names should also match in Match()function then only it will reflect the correct order

E.g:

MonthFiled

Jan

Feb

Mar

April

May

June

July

.

.

.

.

.

Then you have to wrrite like

Match(MonthFiled,'Jan','Feb','Mar'.....)

Exactly same as above its case sensitive

[nikhilgarg]

Hey,

Thankx buddy.

it works.

[nikhilgarg]

Hey,

BUt can you tell em how the following works??

I did not get the working...

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

[#5]

Hi Nikhil, Please see attached file, you can use the sort option and apply the formula. See the attached file.