How to convert number into Month

[#1]

Hi,

I have a scenario like below,

Test=201216

I have to convert this value into month by below case,

201216 as DEC 16, last two digits are number(16), and 3rd and 4th digits represents as month(ex: 12 as DEC,1 as JAN,2 as FEB,etc..)

Thanks,

Mahi

[sunny_talwar]

May be like this:

Month(Date('201216', 'DDMMYY'))

[sunny_talwar]

My bad, try this:

=Month(Date#('201216', 'DDMMYY'))

[#4]

Sunny,

I have to use column name 'Test' to convert the set of values, for example

if 201216 -->DEC 16

200810-->AUG 10

Thanks,

Mahesh

[sunny_talwar]

Try this:

=Date(Date#(Test, 'DDMMYY'), 'MMM YY') as Test

[MarcoWedel]

maybe

=Date(MonthStart(Date#(Test, 'DDMMYY')), 'MMM YY') as Test

to avoid multiple values with the same text representation but different numerical values.

regards

Marco