Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

How to extract a date filed?

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
200502

 

200601
200602

kindly help me on thos to getting a Date field.

Thanks,

Chirumamilla

Tags (1)
4 Replies
Partner
Partner

Re: How to extract a date filed?

try this

load

date#(Period,'YYYYMM') as Period

Chanty4u
Esteemed Contributor III

Re: How to extract a date filed?

try this

load *,

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

;

lakkydev
Contributor II

Re: How to extract a date filed?

Hi,

Use makeDate()

It will help you

For details check in help menu.

Re: How to extract a date filed?

Try with Makedate function

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

Regards

Anand