Sorting

[ashokraju]

I have a colomn called 'BookingPeriod' values like jan 09,feb 09 to dec 16 in irregular order. How to sort these values in ascending order like jan 09 to dec 16.

[tamilarasu]

Hi Ashok,

Try this as sort expression in sort tab.

=Date#(BookingPeriod,'MMM YY')

[Chanty4u]

try below

using match   ...sort tab expression.

=Match(MonthYear,'jan09......'dec16')

[pathiqvd]

Hi,

   Try This,

Match(CAPITALIZE(LEFT(TRIM(fieldnname,3)),

$(=chr(39) & Replace(MonthNames, ';', chr(39) & ',' & chr(39)) & chr(39)))

+ (RIGHT(TRIM(fn),2) * 11)

[ashokraju]

I want dynamically. In future previous years will come that time this will not works.

[ashokraju]

hi..it is not working

[tamilarasu]

I did a test in a sample file and it's working fine. If possible, share your application.

[Anil_Babu_Samineni]

This should work, When you say it is not working you may share sample data

[ninnartx]

Maybe check and see if your field BookingPeriod is stored as text or date format first?

[sunny_talwar]

May be a slight variation of what Tamil has provided:

In the script:

Date(Date#(KeepChar(Upper(BookingPeriod), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'), 'MMMYY'), 'MMM-YY') as BookingPeriod

or front end (dimension or sorting expression)

Date(Date#(KeepChar(Upper(BookingPeriod), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'), 'MMMYY'), 'MMM-YY')