https://community.qlik.com/t5/Talend-Studio/Date-formatting-error/m-p/2210614#M8964 <P>As you have date fields for both input and output,&nbsp;<SPAN>TalendDate.formatDate is not applicable.</SPAN></P> <P><SPAN>TalendDate.formatDate is to convert from string to date datatype.</SPAN></P> <P><SPAN>Simply try to adapt the date format:</SPAN></P> <P><SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lv08.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/128396i4E366A95B7B530B2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lv08.png" alt="0683p000009Lv08.png" /></span></SPAN></SPAN></P> <P><SPAN>The result will be like this:</SPAN></P> <PRE>Starting job test at 23:08 22/05/2017. [statistics] connecting to socket on port 3472 [statistics] connected 20170522 2017-05-22 12:00:00 [statistics] disconnected Job test ended at 23:08 22/05/2017. [exit code=0]</PRE> <P>&nbsp;</P> Mon, 22 May 2017 22:18:07 GMT TRF 2017-05-22T22:18:07Z https://community.qlik.com/t5/Talend-Studio/Date-formatting-error/m-p/2210613#M8963 <P>Hello All,</P> <P>&nbsp; &nbsp; I have &nbsp;my CSV date data which is of form yyyyMMdd form and i want to result as yyyy-MM-dd hh:mm:ss so i used&nbsp;function TalendDate.formatDate("yyyyMMdd"row1.FKDAT) &nbsp;but i am getting error string literal not properly closed by double quotes.I also used function TalendDate.parseDate(<SPAN>"yyyyMMdd"row1.FKDAT) still getting same error<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Talenddate.jpg" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lur8.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/149098iCA0D8E487747FB37/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lur8.jpg" alt="0683p000009Lur8.jpg" /></span></SPAN></SPAN></P> <P>&nbsp;</P> Mon, 22 May 2017 20:28:54 GMT https://community.qlik.com/t5/Talend-Studio/Date-formatting-error/m-p/2210613#M8963 Anonymous 2017-05-22T20:28:54Z https://community.qlik.com/t5/Talend-Studio/Date-formatting-error/m-p/2210614#M8964 <P>As you have date fields for both input and output,&nbsp;<SPAN>TalendDate.formatDate is not applicable.</SPAN></P> <P><SPAN>TalendDate.formatDate is to convert from string to date datatype.</SPAN></P> <P><SPAN>Simply try to adapt the date format:</SPAN></P> <P><SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lv08.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/128396i4E366A95B7B530B2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lv08.png" alt="0683p000009Lv08.png" /></span></SPAN></SPAN></P> <P><SPAN>The result will be like this:</SPAN></P> <PRE>Starting job test at 23:08 22/05/2017. [statistics] connecting to socket on port 3472 [statistics] connected 20170522 2017-05-22 12:00:00 [statistics] disconnected Job test ended at 23:08 22/05/2017. [exit code=0]</PRE> <P>&nbsp;</P> Mon, 22 May 2017 22:18:07 GMT https://community.qlik.com/t5/Talend-Studio/Date-formatting-error/m-p/2210614#M8964 TRF 2017-05-22T22:18:07Z