https://community.qlik.com/t5/Talend-Studio/Change-Date-Format/m-p/2252658#M36236 <P>Hello,</P><P>Lets consider that we input files and they dont have the same date format. I want when I import them to change their date format.. For example We import a file with date format MM/dd/yy , another one with format yyyy/MM/dd and I want both of them to have the format of dd/MM/yyyyy. Thanks.</P> Tue, 14 Jan 2020 09:44:21 GMT DrGenious 2020-01-14T09:44:21Z https://community.qlik.com/t5/Talend-Studio/Change-Date-Format/m-p/2252658#M36236 <P>Hello,</P><P>Lets consider that we input files and they dont have the same date format. I want when I import them to change their date format.. For example We import a file with date format MM/dd/yy , another one with format yyyy/MM/dd and I want both of them to have the format of dd/MM/yyyyy. Thanks.</P> Tue, 14 Jan 2020 09:44:21 GMT https://community.qlik.com/t5/Talend-Studio/Change-Date-Format/m-p/2252658#M36236 DrGenious 2020-01-14T09:44:21Z https://community.qlik.com/t5/Talend-Studio/Change-Date-Format/m-p/2252659#M36237 so first detect date format, then convert to yours.<BR /><BR />the best yay is to convert to date first then convert to string with format.<BR /><BR /> Tue, 14 Jan 2020 09:47:48 GMT https://community.qlik.com/t5/Talend-Studio/Change-Date-Format/m-p/2252659#M36237 fdenis 2020-01-14T09:47:48Z