topic Re: Date Function in QlikView

Date Function

Wed, 24 Dec 2014 13:16:27 GMT

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

Re: Date Function

anbu1984 — Wed, 24 Dec 2014 13:22:33 GMT

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

201312

201401

201402 ];

Re: Date Function

its_anandrjs — Wed, 24 Dec 2014 13:23:23 GMT

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

Re: Date Function

Anonymous — Wed, 24 Dec 2014 13:25:46 GMT

Hi,

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

PFA

Re: Date Function

Thu, 25 Dec 2014 03:54:18 GMT

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

Re: Date Function

Fri, 26 Dec 2014 04:52:48 GMT

@Thank you Subba Reddy i got the desired results.

Re: Date Function

Fri, 26 Dec 2014 16:31:44 GMT

your welcome