https://community.qlik.com/t5/Talend-Studio/String-to-Date-conversion-always-gives-20170101/m-p/2219541#M14306 <P>Hi Team,</P> <P>&nbsp;</P> <P>I am trying to convert a string(20170404) to a date of format YYYYMMDD, since my target is a date format.</P> <P>&nbsp;</P> <P>I tried both tmap and tconverttype both gave me 20170101. Please advise what I might be doing wrong!</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 499px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lv5r.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144001i1B3CCF3A500DF1F7/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lv5r.png" alt="0683p000009Lv5r.png" /></span></SPAN></P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 808px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lv61.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156058i48CD929C6D91150A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lv61.png" alt="0683p000009Lv61.png" /></span></SPAN></P> Wed, 24 May 2017 09:13:16 GMT Anonymous 2017-05-24T09:13:16Z https://community.qlik.com/t5/Talend-Studio/String-to-Date-conversion-always-gives-20170101/m-p/2219541#M14306 <P>Hi Team,</P> <P>&nbsp;</P> <P>I am trying to convert a string(20170404) to a date of format YYYYMMDD, since my target is a date format.</P> <P>&nbsp;</P> <P>I tried both tmap and tconverttype both gave me 20170101. Please advise what I might be doing wrong!</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 499px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lv5r.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144001i1B3CCF3A500DF1F7/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lv5r.png" alt="0683p000009Lv5r.png" /></span></SPAN></P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 808px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lv61.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156058i48CD929C6D91150A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lv61.png" alt="0683p000009Lv61.png" /></span></SPAN></P> Wed, 24 May 2017 09:13:16 GMT https://community.qlik.com/t5/Talend-Studio/String-to-Date-conversion-always-gives-20170101/m-p/2219541#M14306 Anonymous 2017-05-24T09:13:16Z https://community.qlik.com/t5/Talend-Studio/String-to-Date-conversion-always-gives-20170101/m-p/2219542#M14307 <P>Change the date format mask:</P><PRE>TalendDate.parseDate("yyyyMMdd",row1.date_val) </PRE> Wed, 24 May 2017 09:38:37 GMT https://community.qlik.com/t5/Talend-Studio/String-to-Date-conversion-always-gives-20170101/m-p/2219542#M14307 TRF 2017-05-24T09:38:37Z