How to sort month wise in listbox

[kulasekhar]

Hi All,

I have one listbox. find the atach ment.

I want display data month wise like Jan-13

                                                     Jan-14

                                                     Jan-15

                                                     Feb-13

                                                      Feb-14

                                                      Feb-15    Like this

Thanks

Sekhar.

[Peter_Cammaert]

Or maybe shorter (I'm guessing that your listbox already contains a Date() value)?

= Month(DateField)*10000+Year(DateField)

Also works for months in the previous century. Or in the next one

Peter

[kulasekhar]

Thanks a lot Anbu.Helping me