Month year

[#1]

Hi guys I have a small problem...

I have year and Month No.

If Year is 2011 and Month is 1 thn it means its April 2011.

I want to create month year thru func.Monthname.

[deepakk]

hi Erika,

Do the following  steps.

1) go to Script -- and change the Month name format. Currently it begins with Jan;Feb;Mar;... change it to pr;Jun;Jul.....Feb;Mar;

2) Create Date using Makedate function and use the Monthname function on it.

MonthName(MakeDate(Year,Month)) as MonthName.

I hope this helps.

Deepak

[rahulgupta]

Plz find attached app..Hope it helps..

[#4]

Thanks for reply....

but I don't want this...

I can't use monthname.

i have created a field Month &'  'year

Now I want it to convert into numeric  because I need to sort something on its basis.

[perumal_41]

u create a field num(Month) &'  'year

[#6]

Hi,

Can you attach your .qvw?

-Jai

[#7]

Month field is having values as Apr,May,Jun...therefore it can't me converted into Num...as it is a text.

[#8]

Hi,

   Can you try some Inline Table for that,lik

[Month,Num_Month

Apr,01

May,02

.

.

.

.

]

Like this?

-Jai

[#9]

No.No not inline...

[#10]

Ok,If possible attach your application

-Jai