Arrange date in order

[#1]

Hello,

Please somebody help in arranging date in order 'Year and Month'.

Find attached

[#2]

Anyone here to help??

[anbu1984]

Can you explain your requirement with expected output

[jonathandienst]

Hi

You are more likely to get a response if you load the data into a qvw file and create the object for which you require sorting (and reduce the size - you only need a few 100 rows).

Jonathan

[#5]

Hiii,

Use Dual Function to Arrange Date in Order like:-

If(Month='Jan',dual('Jan',1),

If(Month='Feb',dual('Feb',2),

If(Month='Mar',dual('Mar',3),

If(Month='Apr',dual('Apr',4),

If(Month='May',dual('May',5),

If(Month='Jun',dual('Jun',6),

If(Month='Jul',dual('Jul',7),

If(Month='Aug',dual('Aug',8),

If(Month='Sep',dual('Sep',9),

If(Month='Oct',dual('Oct',10),

If(Month='Nov',dual('Nov',11),

If(Month='Dec',dual('Dec',12)

)))))))))))) as Month

Thanks & Regards

Prince Anand

[ashfaq_haseeb]

Hi,

I did this for retirement date.

You can do the same for hire date

Regards

ASHFAQ

[MarcoWedel]

Hi,

maybe this thread helps also:

How do i arrange this date in order

regards

Marco

[#8]

Ashfaq,

Is it possible to select by Year when it is in tree format? This what i want to achieve