Number as text

[#1]

Hi,

I have a few tables representing month as numbers 0, 1, 2 ... to 12. I no want to change the display of these numbers to text; Jan, Feb, March ... and so on. How do I do this?

Cheers,

Nils

[sandeepprasad_j]

Hello Nils,

Use Month() function

hope it helps

Sandeep.

[christian77]

Hi.

In your script:

Month(MakeDate('2222',Month,'22'))   as Month

First you create a date with your month.

After apply Month funktion.

[MK_QSL]

There are multiple ways

You can add an INLINE table in your script...

Load * INLINE

[

     Month, 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

   ];

Or just use the below function to get MonthName from MonthNumber

=Month(MakeDate(Year(Today()),MonthNumber))

[CELAMBARASAN]

Use Month function.

It will give you Both Number and text on using like

Text(FieldName), Num(FieldName)

Ex:

Month(DateField) As FieldName

[Clever_Anjos]

You can use something like

LOAD
  SubField('$(MonthNames)',';',yournumfield) as yourmonthfield

[#7]

thanks, this answer worked half-way . i am now getting the month names to appear, however i would like to also hide the numbers, so that only the month names are showing.

[#8]

as with the answer below, this is also getting em half-way . am now getting the month names to appear, however i would like to also hide the numbers, so that only the month names are showing.

[#9]

hi all,

i still havent gotten a full solution to this, anyone who can give it another try?

I have now gotten the month to appear together with the number of the month, however i need to number to be gone . any ideas?

[Anonymous]

Nils

Just use this :

     Month (  Date# ( num( [YourMonthNumberField] , '00' )   , 'MM' ) )

Should ok in either your load script or your dashboard.

No need to do any Inline Loads.

Best Regards,     Bill