https://community.qlik.com/t5/Talend-Studio/How-to-convert-string-to-date/m-p/2325792#M95356 <P><BR />How to convert string whose value is "29-JUN-2018" (including double parenthesis in its value) to date format?&nbsp;<BR />The expected format is "yyyy-MM-dd'T'hh:mm:ss.SSS"</P> Fri, 29 Jun 2018 10:56:33 GMT Anonymous 2018-06-29T10:56:33Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-string-to-date/m-p/2325792#M95356 <P><BR />How to convert string whose value is "29-JUN-2018" (including double parenthesis in its value) to date format?&nbsp;<BR />The expected format is "yyyy-MM-dd'T'hh:mm:ss.SSS"</P> Fri, 29 Jun 2018 10:56:33 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-string-to-date/m-p/2325792#M95356 Anonymous 2018-06-29T10:56:33Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-string-to-date/m-p/2325793#M95357 first tmap split your string in 3 parts<BR />second Tmap change Jun to 06<BR />third Tmap convert 20180629 to dat then format this Date<BR />TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("yyyyMMdd", 20180629 )) Mon, 02 Jul 2018 07:42:43 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-string-to-date/m-p/2325793#M95357 fdenis 2018-07-02T07:42:43Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-string-to-date/m-p/2325794#M95358 <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mapping.PNG" style="width: 925px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lym2.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/135121i59A94416CC1FD826/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lym2.png" alt="0683p000009Lym2.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="parse.PNG" style="width: 524px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lyvb.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138013iD75E3FBB63BD149D/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lyvb.png" alt="0683p000009Lyvb.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tmap.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lyvg.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133392i2FCF780AA0B93E57/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lyvg.png" alt="0683p000009Lyvg.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="out.PNG" style="width: 679px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lyk0.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/131286iC7DF7BA8EC5BDE60/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lyk0.png" alt="0683p000009Lyk0.png" /></span></SPAN></P> Tue, 03 Jul 2018 11:50:38 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-string-to-date/m-p/2325794#M95358 Anonymous 2018-07-03T11:50:38Z