topic Re: Year conversion in script in QlikView

Year conversion in script

Mon, 16 Jul 2012 17:15:17 GMT

I have a column with the following date format: YYYYMMDD, and I would like to take the years of this column in the script, but with the function year (column_name) it returns me a number 52620 something like that, I wonder what is the correct method the year to get such a column. Thank you.

Re: Year conversion in script

nagaiank — Mon, 16 Jul 2012 17:18:09 GMT

Yiu may try

Left(column_name,4)

Year(Date(Date#(column_name,'YYYYMMDD')))

Re: Year conversion in script

MayilVahanan — Mon, 16 Jul 2012 17:19:26 GMT

Hi,

Try like this,

In script:

Load *,Year(Date(Date#(DateField,'YYYYMMDD'),'YYYY/MM/DD')) as Year from tablename;

(0r)

Can you post a sample?

Hope it helps