Convertion of Date format

[#1]

hello QV,

I have a data field like 201405,201406(YYYYMM) format,I wan to convert it to May 14,Jun 14,

will this help??

Date(Date#(FISCAL_YEAR_MONTH_NUM,YYYYMM),MMMYY) as FiscalMonth

Thanks

[MK_QSL · Accepted solution]

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