topic Converting dates in QlikView https://community.qlik.com/t5/QlikView/Converting-dates/m-p/656168#M239585 <HTML><HEAD></HEAD><BODY><P>How do you separate a date in the format YYYYWW (i.e 201432) to year, YYYY (2014) and date WW(32)?</P></BODY></HTML> Tue, 26 Aug 2014 21:42:27 GMT 2014-08-26T21:42:27Z Converting dates https://community.qlik.com/t5/QlikView/Converting-dates/m-p/656168#M239585 <HTML><HEAD></HEAD><BODY><P>How do you separate a date in the format YYYYWW (i.e 201432) to year, YYYY (2014) and date WW(32)?</P></BODY></HTML> Tue, 26 Aug 2014 21:42:27 GMT https://community.qlik.com/t5/QlikView/Converting-dates/m-p/656168#M239585 2014-08-26T21:42:27Z Re: Converting dates https://community.qlik.com/t5/QlikView/Converting-dates/m-p/656169#M239586 <HTML><HEAD></HEAD><BODY><P>if your field is a string (as I believe) and not a date, you can use left(fieldname,4) for year and right(fieldname,2) for week, even from your load script to optimize your ram usage.</P></BODY></HTML> Tue, 26 Aug 2014 21:46:38 GMT https://community.qlik.com/t5/QlikView/Converting-dates/m-p/656169#M239586 Anonymous 2014-08-26T21:46:38Z