Convert YYYYMMDD into Monthname

[#1]

Hello All,

I need to convert 'YYYYMMDD' into monthname like 'Jan. , Feb. , etc....'

I manage to convert it into date using the below:

Date(alt(Date#(DATE, 'YYYYMMDD')), 'DD/MM/YYYY') as Date_Interview,

Any idea?

KR,

Hasvine

[sangeethag]

Hi

Can you write your output expectation clearly?

For Month Name you just try this, use either in Script / expression

LOAD Date(MakeDate(left(Date,4),Mid(Date,5,2),Right(Date,2)),'YYYYMMDD') As Date,

     Date(MakeDate(left(Date,4),Mid(Date,5,2),Right(Date,2)),'YYYYMMMDD') As DateMonthName,

     Month(Date(MakeDate(left(Date,4),Mid(Date,5,2),Right(Date,2)),'YYYYMMMDD')) As MonthName

FROM

(ooxml, embedded labels, table is Sheet1);

Output will be:

[Anonymous]

Agreed, Same can be achieved by removing Date() & Alt() function from the above mentioned expression.

I thinks,she might be using Alt() functionality, then I just add month() to her expression. Else this would be working perfectly as well..

Month(Date#(DATE, 'YYYYMMDD')) as Month

[rajeshforqlikvi]

Hi You can use like this as below example:

=Date(Addmonths(today(),-1),'MMM')

[Anonymous]

month(DATE COLUMN) AS DATE _iNTERVIEW