topic Date transformation in QlikView https://community.qlik.com/t5/QlikView/Date-transformation/m-p/489122#M182803 <HTML><HEAD></HEAD><BODY><P>i have the following date format which i wish to transform</P><P></P><P>1302-4</P><P></P><P>13 is Year ie . 2013</P><P>02 is week example week 2</P><P>-4th day of week nr 02</P><P></P><P>the date here would be <STRONG>2013-01-10</STRONG>.</P><P></P><P>i have tried to use the following statement without success.</P><P></P><P>Makedate(2000+ num(left(Leveranstid,2)), num(week(mid(Leveranstid,3,2))), num(day(right(Leveranstid,2))))</P><P></P><P>best</P><P>Brad</P></BODY></HTML> Wed, 06 Nov 2013 15:08:18 GMT 2013-11-06T15:08:18Z Date transformation https://community.qlik.com/t5/QlikView/Date-transformation/m-p/489122#M182803 <HTML><HEAD></HEAD><BODY><P>i have the following date format which i wish to transform</P><P></P><P>1302-4</P><P></P><P>13 is Year ie . 2013</P><P>02 is week example week 2</P><P>-4th day of week nr 02</P><P></P><P>the date here would be <STRONG>2013-01-10</STRONG>.</P><P></P><P>i have tried to use the following statement without success.</P><P></P><P>Makedate(2000+ num(left(Leveranstid,2)), num(week(mid(Leveranstid,3,2))), num(day(right(Leveranstid,2))))</P><P></P><P>best</P><P>Brad</P></BODY></HTML> Wed, 06 Nov 2013 15:08:18 GMT https://community.qlik.com/t5/QlikView/Date-transformation/m-p/489122#M182803 2013-11-06T15:08:18Z Re: Date transformation https://community.qlik.com/t5/QlikView/Date-transformation/m-p/489123#M182804 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>date(num(Makedate(2000+ num(left(Leveranstid,2)))) + </P><P>((num(week(mid(Leveranstid,3,2))) * 7) +</P><P>num(day(right(Leveranstid,2))))), 'YYYY-MM-DD')</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 06 Nov 2013 15:19:46 GMT https://community.qlik.com/t5/QlikView/Date-transformation/m-p/489123#M182804 marcus_sommer 2013-11-06T15:19:46Z Re: Date transformation https://community.qlik.com/t5/QlikView/Date-transformation/m-p/489124#M182805 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>makeweekdate(Year(Date#(left('1302-4',2),'YY')), num(mid('1302-4',3,2)),num(right('1302-4',1)))</P></BODY></HTML> Wed, 06 Nov 2013 15:24:44 GMT https://community.qlik.com/t5/QlikView/Date-transformation/m-p/489124#M182805 2013-11-06T15:24:44Z