https://community.qlik.com/t5/Talend-Studio/how-to-get-date-in-string-format/m-p/2291375#M64562 <P>I need to get date in string format like 09 january 2017.&nbsp;</P><P>i need to pass this value in output excel</P> Thu, 14 Jun 2018 12:05:32 GMT Darmesh 2018-06-14T12:05:32Z https://community.qlik.com/t5/Talend-Studio/how-to-get-date-in-string-format/m-p/2291375#M64562 <P>I need to get date in string format like 09 january 2017.&nbsp;</P><P>i need to pass this value in output excel</P> Thu, 14 Jun 2018 12:05:32 GMT https://community.qlik.com/t5/Talend-Studio/how-to-get-date-in-string-format/m-p/2291375#M64562 Darmesh 2018-06-14T12:05:32Z https://community.qlik.com/t5/Talend-Studio/how-to-get-date-in-string-format/m-p/2291376#M64563 TalendDate.formatDate("any format you want", yourDateValueAsADateType)<BR /> Thu, 14 Jun 2018 12:30:18 GMT https://community.qlik.com/t5/Talend-Studio/how-to-get-date-in-string-format/m-p/2291376#M64563 Jesperrekuh 2018-06-14T12:30:18Z https://community.qlik.com/t5/Talend-Studio/how-to-get-date-in-string-format/m-p/2291377#M64564 <P><SPAN>TalendDate.formatDate("dd MMMM yyyy",<STRONG>TalendDate.getCurrentDate()</STRONG>) to populate your output field which must be declared as a String.</SPAN></P><P>&nbsp;</P><P>&nbsp;</P><P><SPAN><STRONG>TalendDate.getCurrentDate()</STRONG> replace this with your date field input.</SPAN></P> Thu, 14 Jun 2018 12:44:50 GMT https://community.qlik.com/t5/Talend-Studio/how-to-get-date-in-string-format/m-p/2291377#M64564 aashish_21nov 2018-06-14T12:44:50Z