topic I need to convert string to date format in Talend Studio https://community.qlik.com/t5/Talend-Studio/I-need-to-convert-string-to-date-format/m-p/2368218#M131509 <P>Hi Folks,</P> <P>&nbsp;</P> <UL> <LI>When I import my excel in talend</LI> <LI>My date column datatype is string.</LI> <LI>My date column value is there in this format (<SPAN>42905). </SPAN></LI> <LI><SPAN>Please help me how to convert this number to date .</SPAN></LI> </UL> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 04 Oct 2017 12:40:33 GMT RAJ6 2017-10-04T12:40:33Z I need to convert string to date format https://community.qlik.com/t5/Talend-Studio/I-need-to-convert-string-to-date-format/m-p/2368218#M131509 <P>Hi Folks,</P> <P>&nbsp;</P> <UL> <LI>When I import my excel in talend</LI> <LI>My date column datatype is string.</LI> <LI>My date column value is there in this format (<SPAN>42905). </SPAN></LI> <LI><SPAN>Please help me how to convert this number to date .</SPAN></LI> </UL> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 04 Oct 2017 12:40:33 GMT https://community.qlik.com/t5/Talend-Studio/I-need-to-convert-string-to-date-format/m-p/2368218#M131509 RAJ6 2017-10-04T12:40:33Z Re: I need to convert string to date format https://community.qlik.com/t5/Talend-Studio/I-need-to-convert-string-to-date-format/m-p/2368219#M131510 <P>what is this&nbsp;<SPAN>42905 means for MDDYY??</SPAN></P><P>&nbsp;</P><P><SPAN>Can you specify the date format..&nbsp;</SPAN></P> Wed, 04 Oct 2017 13:07:00 GMT https://community.qlik.com/t5/Talend-Studio/I-need-to-convert-string-to-date-format/m-p/2368219#M131510 ashif2 2017-10-04T13:07:00Z Re: I need to convert string to date format https://community.qlik.com/t5/Talend-Studio/I-need-to-convert-string-to-date-format/m-p/2368220#M131511 <P>this is the format&nbsp;<SPAN>MDDYY</SPAN></P> Wed, 04 Oct 2017 14:25:05 GMT https://community.qlik.com/t5/Talend-Studio/I-need-to-convert-string-to-date-format/m-p/2368220#M131511 RAJ6 2017-10-04T14:25:05Z Re: I need to convert string to date format https://community.qlik.com/t5/Talend-Studio/I-need-to-convert-string-to-date-format/m-p/2368221#M131512 <P>Add Variable Port&nbsp; named:<BR />FormatDate&nbsp; = row2.Dated.length()==5?"0"+row2.Dated:row2.Dated&nbsp;</P><P>In the tMap Output:&nbsp;</P><P>TalendDate.parseDate("MMDDYY",Var.FormatDate)&nbsp;</P> Wed, 04 Oct 2017 14:46:15 GMT https://community.qlik.com/t5/Talend-Studio/I-need-to-convert-string-to-date-format/m-p/2368221#M131512 ashif2 2017-10-04T14:46:15Z