How to convert YYYYMM to MON YYYY

[#1]

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

Thanks

[MayilVahanan · Accepted solution]

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')

[pgrenier]

Hello Faisal,

You can use the following:

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

Cheers,

Philippe

[rustyfishbones]

You could try

[#5]

Thanks All