how to convert month number into month name

[Karim_Khan]

RIGHT([Fiscal Period ID],2) AS Month is showing month like 1,2,3,4,5,6,7,8,9 need to convert into Jan,Feb Mar,Apr

[stephenedberkg]

write inline code like this   &  finaly mapping to your Fiscal Period ID.

Months:

Mapping LOAD * Inline

[months, monthNo.

JAN, 1

FEB, 2

MAR, 3

APR, 4

MAY, 5

JUn, 6

JUL, 7

AUG, 8

SEP, 9

OCT, 10

NOV, 11

DEC, 12

];

[stephenedberkg]

the best way is try master caledar

[Karim_Khan]

Thank you very much

[Karim_Khan]

Thank you very much

[Karim_Khan]

Can any body help on this?

how to create the fiscal calender with existing data which contains only FISCAL Period ID no Date input

[maxgro]

Please close this thread (mark helpful and/or correct answers if any) and open a new one with the new question.

Thanks