Month Sort Issue

[nihhalmca]

Hi All,

I have month field like 01,02,03....12 and i converted it at front end as below

Pick(Match(Month,01,01,03,04,05,06,07,08,09,10,11,12), 'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

And I tried to sort order like Jan...Dec however i could not make it. Could you please assist with this.

Thanks,

Nihhal.

[sunny_talwar]

Use this instead

Month(Date#(Month, 'MM'))