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

[Chanty4u]

Date(alt(Date#(DATE, 'YYYYMMDD')), 'MMM') as Date_Interview,

or u want only month name ?   or with date format?

[tresB]

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

[MayilVahanan]

Hi

Try like this

Load *, Month(Date_Interview) AS Month, Year(Date_Interview) AS Year;

Load *,

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

YourTableName;

[#5]

I want the month name.

I managed to do the date.

Many Thanks,

Hasvine

[Anonymous · Accepted solution]

just add Month() to your exprression like this?

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

[jagan]

HI,

Try like this

LOAD

*,

Month(Date_Interview) AS Month_Interview;

LOAD

*,

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

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

[#8]

Thanks.

It works.

Kind Regards,

Hasvine

[tresB]

Some of the functions here are unnecessary I see, the same could be got using a simpler expression I shared above.

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

It's better to be better. Isn't it?

[rajeshforqlikvi]

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