topic Re: How to extract a date filed? in QlikView

How to extract a date filed?

Wed, 09 Nov 2016 12:27:09 GMT

Hi All,

I am having a doubt in extracting the date filed from Year and Month fields.I have data like this;

Period

200501

200502

200601

200602

kindly help me on thos to getting a Date field.

Thanks,

Chirumamilla

Anonymous — Wed, 09 Nov 2016 14:11:29 GMT

try this

load

date#(Period,'YYYYMM') as Period

Chanty4u — Mon, 14 Nov 2016 07:47:11 GMT

try this

load *,

date(Date#(datefield,'YYYYMM'),'YYYYMM') AS Preiod_Date

;

Anonymous — Mon, 14 Nov 2016 07:51:06 GMT

Hi,

Use makeDate()

It will help you

For details check in help menu.

its_anandrjs — Mon, 14 Nov 2016 08:02:47 GMT

Try with Makedate function

Makedate(Year(Period),Month(Period)) as Datefield

Regards

Anand