All,
To cater to a very specific requirement, we are loading the date values into an Info Object (Headcount Load Date) which is of type "Characteristic" and not "DATS".
This Object essentially gets loaded with the system date in the format DD.MON.YYYY (20.MAY.2009) on a weekly basis.
When a variable is created for this Object, we have the drop downs being listed like below in a random order:
10.JAN.2009
14.MAR.2009
01.NOV.2008
07.MAR.2009
13.DEC.2008
17.MAY.2009
22.SEP.2008
Now, the requirement from the User is that these Date values should be appearing based on the most recent load date instead of them having to scroll down to pick the most recent load date. As shown below:
17.MAY.2009
14.MAR.2009
07.MAR.2009
10.JAN.2009
13.DEC.2008
01.NOV.2008
22.SEP.2008
Would the above sequence be possible to achieve? When we use the ascending or the descending option in the Drop downs, it's only sorting based on the number and not on the months. The option of ascending or descending in the drill down therefore does cater to the requirement.
Do you guys have any idea?
Regards,
Manick