Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i need to display a column in the list box. the column contains values like
Month id
-------------
1
2
3
4
but instead of numbers, i need to show them as a month format. for eg. JAN for 1 and FEB for 2. I should not use some other columns in the list box, because month id am using that in calculation. Any ideas how to give aliasing here..
Thanks in advance,
Praveen.
try this
Date(Date#(Month id,'MM'),'MMM') in expression of list box
Regards
Sivaraj
Use a list box with expression Month(Month id) instead of field.
It is the last option in the Field drop down.
Hi
You can use the Inline function to achieve this. Please find the code below.
LOAD * INLINE [
Monthid, MonthName
1, Jan
2, Feb
3, Mar
4, Apr
5, May
6, Jun
7, Jul
8, Aug
9, Sep
10, Oct
11, Nov
12, Dec
];
After loading this map the MonthName to the list box. Both Month id and Month name will be available and you can use the month id for calculation too. Hope this will help you.
try this
Date(Date#(Month id,'MM'),'MMM') in expression of list box
Regards
Sivaraj
thanks sivaraj, it worked for me!!!