Date Function

[#1]

Hi all ,

I got data in my excel as follows, month info as 201312

                                                                      201401

                                                                      201402

How can i get month and date info as December,January,February,2013,2014 (Correct use of date function)

i need your help,

thanks

[anbu1984]

Load Month(Date#(Dt,'YYYYMM')) As Mth,Year(Date#(Dt,'YYYYMM')) As Yr  Inline [

Dt

201312

201401

201402 ];

[its_anandrjs]

Hi,

Try this ways

LOAD *,

Date(MonthName(Dates),'MMMM YYYY') as MonthNames;

Year(Dates) as Year,

Month(Dates) as Month;

LOAD Date(Date#(Dates,'YYYYMM'),'YYYYMM') as Dates;

LOAD * Inline [

Dates

201312

201401

201402

];

Regards

Anand

[Anonymous]

Hi,

Function : Date(makedate(left(Period,4),right(Period,2),1), 'MMMM YYYY')as Month_Year;

PFA

[#5 · Accepted solution]

Hi,

Please try this, I hope its help full for you.

Month(Date#('201312','YYYYMM'))  as Mnth,

Year(Date#('201312','YYYYMM'))  as Yr

Regards,

Sub2u

[#6]

@Thank you Subba Reddy i got the desired results.

[#7]

your welcome