Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to convert YYYYMM to MON YYYY


Hi All, I have CalMonth format like 201206,, and i would like to convert it to Jun 2012 or like Jun 12

Thanks

1 Solution

Accepted Solutions
MayilVahanan

Hi

Try like this

=Date(Date#(201206,'YYYYMM'),'MMM YY') <- Jun 12

=Date(Date#(201206,'YYYYMM'),'MMM YYYY') <- Jun 2012

or

=Date(Date#(DateField,'YYYYMM'),'MMM YY')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

4 Replies
MayilVahanan

Hi

Try like this

=Date(Date#(201206,'YYYYMM'),'MMM YY') <- Jun 12

=Date(Date#(201206,'YYYYMM'),'MMM YYYY') <- Jun 2012

or

=Date(Date#(DateField,'YYYYMM'),'MMM YY')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
pgrenier
Partner - Creator III
Partner - Creator III

Hello Faisal,

You can use the following:

Date(Date#(CalMonth, 'YYYYMM'), 'MMM YYYY')

Cheers,

Philippe

rustyfishbones
Master II
Master II

You could try

2013-10-10_2206.png

Not applicable
Author

Thanks All