month in num to string

[arulsettu]

Hi,

i am having month filed like this

month

0

1

2

3

4

5

6

7

8

9

10

11

12

i want to convert this in jan,feb,mar......

so used this Month(MakeDate('2014',monthfield)) as newmonth

its working i used this newmonth field to convert quarter but it is not deriving the quarter. also i used this newmonth filed in chart its not giving the result. if i use old month field its giving desired result

any suggestions plz?

[sujeetsingh]

You can use Wildmatch to give the num months name.

[Anonymous]

Maybe something like this :

     date(MakeDate('2014',monthfield),'MMM')

[PrashantSangle]

Hi,

Try this,

Date(date#(FieldName,'MM'),'MMM')

Regards

[amit_saini]

Arul,

Try this:

MonthName:

Mapping

LOAD * INLINE [

    F1, F2

    January, Jan

    February, Feb

    March, Mar

    April, Apr

    May, May

    June, Jun

    July, Jul

    August, Aug

    September, Sep

    October, Oct

    November, Nov

    December, Dec

];

MonthNum:

Mapping

LOAD * INLINE [

    F1, F2

    January, 1

    February, 2

    March, 3

    April, 4

    May, 5

    June, 6

    July, 7

    August, 8

    September, 9

    October, 10

    November, 11

    December, 12

];

Thanks,

AS

[Roop]

You can convert it to a date:

Text(Month(Date('01/'&MonthField&'/2015')

It doesn't really matter what year you are using in this syntax.

What is month 0 ?

[arulsettu]

Hi Max,

           its giving the month and quarter but when i use this month in my chart expression result is nothing can u tell me why?

[PrashantSangle]

Hi,

Just check do you have data for that combination??

and if possible share you sample app.

Regards

[hariprasadqv]

Try This.

=month(MakeDate(2015,[month]))

[arulsettu]

Hi

PFA

here TBA_CAL_MONTH is old month working in chart

new one is TBAL_month is not working in chart

plz suggest