Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to convert number into Month

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

5 Replies
sunny_talwar

May be like this:

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

sunny_talwar

My bad, try this:

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

Not applicable
Author

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