reply urgent please

[#1]

Hi...i have a column Fiscal Month (please find the attachment) , in that months are displying like 1,2,3,4,...but my issue is need to disply 1 as JAN ,2 as FEB......, It is possible can anyone please help me to get this...

Thanks & Regards,

Sh.

[Sokkorn]

Hi Sh.,

You can create below expression

=Pick([FiscalMonthNumber],'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC')

Where [FiscalMonthNumber] is your month number field.

Regards,

Sokkorn

[#3]

Hi..Thanks For that Reply, But where i have to give that expression ...in the script level or some where?....i need to show FiscalMonthNumber as a list box...

Regards,

Sh.

[Sokkorn]

Hi Sh.,

Do this: Create new List Box -> In drop down Field choose <Expression> -> past expression here

Regards,

Sokkorn

[#5]

Or else

if want at the script level,

create inline

Fiscal Month, Display Month

1, JAN

2, FEB

3, MARCH

then just link both the fiscal months and use Display Month in the list box.

tht will solve ur problem.

[#6]

Can you upload your sample application.

[er_mohit]

I think You have To try this in script

NameMap:

mapping LOAD * INLINE [

    FiscalMonthNumber, FiscalMonthName

    1, JAN

    2, FEB

    3, MAR

    4, APR

    5, MAY

    6, JUN

    7, JUL

    8, AUG

    9, SEP

    10, OCT

    11, NOV

    12, DEC

];

Map  FiscalMonthNumber using NameMap;

LOAD * INLINE [

    FiscalMonthNumber

    1

    2

    3

    4

    5

    6

    7

    8

    9

    10

    11

    12

];

hope it helps