https://community.qlik.com/t5/Talend-Studio/tmap-Extract-Month-Name-from-date-field/m-p/2259720#M41097 <FONT color="#242729"><FONT size="2"><FONT face="Arial,">we are trying to extract month name from the&nbsp;date field.</FONT></FONT></FONT> <BR /> <FONT color="#242729"><FONT size="2"><FONT face="Arial,"><B>Input :</B>&nbsp;date type field 2016-11-01</FONT></FONT></FONT> <BR /> <FONT color="#242729"><FONT size="2"><FONT face="Arial,"><B>we tried:</B></FONT></FONT></FONT> <BR /> <FONT color="#242729"><FONT size="2"><FONT face="Arial,">TalendDate.formatDate("MMMM",row1.Date)</FONT></FONT></FONT> <BR /> <FONT color="#242729"><FONT size="2"><FONT face="Arial,"><B>Output:</B></FONT></FONT></FONT> <BR /> <FONT color="#242729"><FONT size="2"><FONT face="Arial,">November</FONT></FONT></FONT> <BR /> <BR /> <FONT color="#242729"><FONT size="2"><FONT face="Arial,">How to extract full month name from date type with value&nbsp;</FONT></FONT></FONT> <FONT color="#242729"><FONT size="2">&nbsp;</FONT></FONT> <FONT color="#242729"><FONT size="2">2016-11-01?</FONT></FONT> <FONT color="#242729"><FONT size="2">&nbsp;</FONT></FONT> Sat, 16 Nov 2024 10:19:26 GMT gt0731 2024-11-16T10:19:26Z https://community.qlik.com/t5/Talend-Studio/tmap-Extract-Month-Name-from-date-field/m-p/2259720#M41097 <FONT color="#242729"><FONT size="2"><FONT face="Arial,">we are trying to extract month name from the&nbsp;date field.</FONT></FONT></FONT> <BR /> <FONT color="#242729"><FONT size="2"><FONT face="Arial,"><B>Input :</B>&nbsp;date type field 2016-11-01</FONT></FONT></FONT> <BR /> <FONT color="#242729"><FONT size="2"><FONT face="Arial,"><B>we tried:</B></FONT></FONT></FONT> <BR /> <FONT color="#242729"><FONT size="2"><FONT face="Arial,">TalendDate.formatDate("MMMM",row1.Date)</FONT></FONT></FONT> <BR /> <FONT color="#242729"><FONT size="2"><FONT face="Arial,"><B>Output:</B></FONT></FONT></FONT> <BR /> <FONT color="#242729"><FONT size="2"><FONT face="Arial,">November</FONT></FONT></FONT> <BR /> <BR /> <FONT color="#242729"><FONT size="2"><FONT face="Arial,">How to extract full month name from date type with value&nbsp;</FONT></FONT></FONT> <FONT color="#242729"><FONT size="2">&nbsp;</FONT></FONT> <FONT color="#242729"><FONT size="2">2016-11-01?</FONT></FONT> <FONT color="#242729"><FONT size="2">&nbsp;</FONT></FONT> Sat, 16 Nov 2024 10:19:26 GMT https://community.qlik.com/t5/Talend-Studio/tmap-Extract-Month-Name-from-date-field/m-p/2259720#M41097 gt0731 2024-11-16T10:19:26Z https://community.qlik.com/t5/Talend-Studio/tmap-Extract-Month-Name-from-date-field/m-p/2259721#M41098 Sorry, but what the problem? Is November not a full month name? <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MBrm.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136771i72A28EDAD393D872/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MBrm.png" alt="0683p000009MBrm.png" /></span> Thu, 13 Oct 2016 10:29:43 GMT https://community.qlik.com/t5/Talend-Studio/tmap-Extract-Month-Name-from-date-field/m-p/2259721#M41098 vapukov 2016-10-13T10:29:43Z