Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Date(Date#(DateField,'YYYYMM'),'MMM YY') as DateField
Date(Date#(DateField,'YYYYMM'),'MMM YY') as DateField