topic Re: YYYYMMWW in QlikView

YYYYMMWW

Tue, 17 Feb 2015 09:10:38 GMT

Hi,

How to create YYYYMMWW from date in script.

Rahul

Tue, 17 Feb 2015 09:27:28 GMT

Hi Rahul,

Please find the below script

hope it will be usefull.

=Num(Year(DateField),'0000') & Num(Month(DateField),'00') & Num(Week(DateField),'00')

Regards

jagan — Tue, 17 Feb 2015 09:29:35 GMT

Hi,

Try like this

Data:

LOAD

Date(Today(), 'YYYYMM') & Num(Week(Today()), '00') AS YYYYMMWW

FROM DataSource;

Regards,

Jagan.

anbu1984 — Tue, 17 Feb 2015 09:30:51 GMT

Date(DateField,'YYYYMM') & Right('0'&Week(DateField),2) As DateField

maxgro — Tue, 17 Feb 2015 09:34:44 GMT

load

.....,

date(yourdatefield, 'YYYYMM') & num(Week(yourdatefield), '00') as NewField,

.....

from

yoursource;