converting 0calday to get month values - Jan,Feb,March etc
In my bex report , i want to display the months from 0calmonth or 0monyear object.
I have values like 012205,02225 etc..And i want values like Jan,Feb...
I have tried by using characteristics but the values are not in correct sorting..
I have uploaded jan,feb,march..etc but when i view in report it shows april,augutst..in alphabetical
ascending order or descending order like July, June...
Please suggest me which object should I use to get out as months Jan,feb,march..etc..from my value..
There is no constraints that I should use only 0calday or another objects...
My report should display for this year 2005 for this month Jan,Feb...... These are production report values...