https://community.qlik.com/t5/Talend-Studio/String-to-Date-Conversion-and-back-to-String/m-p/2289911#M63248 HI,<BR />Use Formatdate and parsedate together. It will solve your problem. Just check some old resolved topics of Old Talend Community. U will be able to do it Sat, 21 Apr 2018 15:20:56 GMT abhi90 2018-04-21T15:20:56Z https://community.qlik.com/t5/Talend-Studio/String-to-Date-Conversion-and-back-to-String/m-p/2289910#M63247 <P>Hi,</P> <P>&nbsp;</P> <P>I am having a strange problem. My source is a Excel file which has a date field. I read the date field as string as it in 1-Jan-2017 format. Using tMap I convert it into Date and change it to&nbsp; 01-01-2016. Now when I again convert it back to string using tConvertType the month changes to 00. So irrespective of the date the month is defaulted to 00.</P> <P>&nbsp;</P> <P>How do I overcome this issue ?</P> Sat, 21 Apr 2018 04:25:24 GMT https://community.qlik.com/t5/Talend-Studio/String-to-Date-Conversion-and-back-to-String/m-p/2289910#M63247 sunbaj 2018-04-21T04:25:24Z https://community.qlik.com/t5/Talend-Studio/String-to-Date-Conversion-and-back-to-String/m-p/2289911#M63248 HI,<BR />Use Formatdate and parsedate together. It will solve your problem. Just check some old resolved topics of Old Talend Community. U will be able to do it Sat, 21 Apr 2018 15:20:56 GMT https://community.qlik.com/t5/Talend-Studio/String-to-Date-Conversion-and-back-to-String/m-p/2289911#M63248 abhi90 2018-04-21T15:20:56Z