Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Please somebody help in arranging date in order 'Year and Month'.
Find attached
Anyone here to help??
Can you explain your requirement with expected output
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
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
Hi,
I did this for retirement date.
You can do the same for hire date
Regards
ASHFAQ
Ashfaq,
Is it possible to select by Year when it is in tree format? This what i want to achieve