https://community.qlik.com/t5/Talend-Studio/Date-datatypes/m-p/2365034#M128695 <P>Hi All,</P><P></P><P></P><P>I have 2 different date formats in one singe row , so am trying to convert them into one format </P><P></P><P></P><P>for example my data is in below 2 formats </P><P></P><P></P><P>mm/dd/yyyy</P><P>EEE MMM dd HH:mm:ss zzz yyyy</P><P></P><P></P><P>and my output format should be in </P><P></P><P></P><P>mm/dd/yyyy</P><P></P><P></P><P>Can anyone suggest how to get this.</P><P></P><P></P><P>Thanks in advance</P><P>lmit</P> Tue, 07 Sep 2021 06:22:05 GMT lmit 2021-09-07T06:22:05Z https://community.qlik.com/t5/Talend-Studio/Date-datatypes/m-p/2365034#M128695 <P>Hi All,</P><P></P><P></P><P>I have 2 different date formats in one singe row , so am trying to convert them into one format </P><P></P><P></P><P>for example my data is in below 2 formats </P><P></P><P></P><P>mm/dd/yyyy</P><P>EEE MMM dd HH:mm:ss zzz yyyy</P><P></P><P></P><P>and my output format should be in </P><P></P><P></P><P>mm/dd/yyyy</P><P></P><P></P><P>Can anyone suggest how to get this.</P><P></P><P></P><P>Thanks in advance</P><P>lmit</P> Tue, 07 Sep 2021 06:22:05 GMT https://community.qlik.com/t5/Talend-Studio/Date-datatypes/m-p/2365034#M128695 lmit 2021-09-07T06:22:05Z https://community.qlik.com/t5/Talend-Studio/Date-datatypes/m-p/2365035#M128696 <P>Hi @none none​&nbsp;, I can suggest you to read the data as a string and use a custom routine to transform it to a date from different format.</P><P>Send me love and kudos</P> Tue, 07 Sep 2021 07:19:46 GMT https://community.qlik.com/t5/Talend-Studio/Date-datatypes/m-p/2365035#M128696 gjeremy1617088143 2021-09-07T07:19:46Z