topic Re: if statement in QlikView

if statement

Tue, 10 Dec 2013 09:54:41 GMT

i have the following case

whereby my DATE field is not probably formatted.

hence i do a transformation on the field.

Makedate(2000+ num(left(DATE,2)), num(mid(DATE,3,2)), num(right(DATE,2)

however i have data that stretches from 1997 to 2000.

so i tried the following withoiut sucess

if(left(DATE,2) < 90,

Makedate(2000+ num(left(DATE,2)), num(mid(DATE,3,2)), num(right(DATE,2),

MakeDate(1900+ num(left(DATE,2)), num(mid(DATE,3,2)),num(right(DATE,2))

)))) as LeveransDatum

please see application attached

help is greatly appreciated

brad

stabben23 — Tue, 10 Dec 2013 10:06:21 GMT

Hi,

if(left(DATE,2) < 90 will give you the first two, like 19 or 20.

//Stabben

stabben23 — Tue, 10 Dec 2013 11:04:23 GMT

Hi, try this instead.

date(date#(DATE,'YYMMDD'),'YYYY-MM-DD') as LeveransDatum

//Stabben