topic Re: Create a Date into the script in QlikView

Create a Date into the script

Anonymous — Wed, 22 Jun 2016 12:41:51 GMT

Hello,

I would like to create a date because i only have the YEAR on my field and i would set the date 01/01/YEAR for example, and convert to integer this date into my field AsOf.

The Script:

The AsOf field:

How can i do that please ?

Thanks you in advance for your help.

Sébastien.

Re: Create a Date into the script

ciaran_mcgowan — Wed, 22 Jun 2016 12:45:19 GMT

MakeDate(YEAR,1,1) AS AsOf_Date

To make it a number:

Num(MakeDate(YEAR,1,1)) AS AsOf_Date

Re: Create a Date into the script

arulsettu — Wed, 22 Jun 2016 12:45:39 GMT

try like this

date(YEAR) as AsOf

you will get date field

then you can derive year from that

year(AsOf) as year

Re: Create a Date into the script

Anonymous — Wed, 22 Jun 2016 13:08:48 GMT

Thanks a lot it works perfectly !