Month function

[prabhas277]

Hi Experts,

I have one filed called "monthyear" . in my pivot table monthyear is the dimension. there it shows 42370,42430..like that instead  jan ,fed,...dec

How i can change the those numerical values into text?

if i writhe month(42370) then it will give the jan.. but here  i want dynamically?

pl help me on this

Thanks in advance

[surendraj]

Try with

month(Date(42370)) -->It will give you jan.

In script level..

month(Date(Filed name)) as Month

So here

month(Date(monthyear)) as Month.

[tresB]

May be just -

Month(monthyear) ?

[dsharmaqv]

Simply use

=Date(monthyear)

or if you display month then

=Month(monthyear)

i did not understood what do you mean by dynamically?

[muthukumar77]

Hi,

Use

=Month(42370)

it will be return "Jan"