topic Re: subfield not working in QlikView https://community.qlik.com/t5/QlikView/subfield-not-working/m-p/1066181#M640087 <HTML><HEAD></HEAD><BODY><P>Try this instead:</P><P></P><P><STRONG>Date(Date#(Left(created_time, 10), 'YYYY-MM-DD'), 'YYYY/MM/DD')</STRONG></P></BODY></HTML> Thu, 18 Feb 2016 18:23:32 GMT sunny_talwar 2016-02-18T18:23:32Z subfield not working https://community.qlik.com/t5/QlikView/subfield-not-working/m-p/1066180#M640086 <HTML><HEAD></HEAD><BODY><P>Subfield(created_time,'-',1) &amp;'/'&amp; Subfield(created_time,'-',2) &amp;'/'&amp; Subfield(created_time,'T',3)</P><P><IMG alt="fb_date.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/115143_fb_date.png" style="height: 354px; width: 620px;" /></P><P>thirs subfield should return 09 but it is not returning 09</P></BODY></HTML> Thu, 18 Feb 2016 16:07:46 GMT https://community.qlik.com/t5/QlikView/subfield-not-working/m-p/1066180#M640086 2016-02-18T16:07:46Z Re: subfield not working https://community.qlik.com/t5/QlikView/subfield-not-working/m-p/1066181#M640087 <HTML><HEAD></HEAD><BODY><P>Try this instead:</P><P></P><P><STRONG>Date(Date#(Left(created_time, 10), 'YYYY-MM-DD'), 'YYYY/MM/DD')</STRONG></P></BODY></HTML> Thu, 18 Feb 2016 18:23:32 GMT https://community.qlik.com/t5/QlikView/subfield-not-working/m-p/1066181#M640087 sunny_talwar 2016-02-18T18:23:32Z