topic Re: converting month year in QlikView https://community.qlik.com/t5/QlikView/converting-month-year/m-p/15949#M785432 <HTML><HEAD></HEAD><BODY><P>=Year(Timestamp(<SPAN style="font-size: 13.3333px;">CREATION_DATE</SPAN>,'DD-MMM-YYYY hh:mm:ss'))</P><P></P><P>=Month(Timestamp(<SPAN style="font-size: 13.3333px;">CREATION_DATE</SPAN>,'DD-MMM-YYYY hh:mm:ss'))</P></BODY></HTML> Tue, 13 Mar 2018 07:54:49 GMT shiveshsingh 2018-03-13T07:54:49Z converting month year https://community.qlik.com/t5/QlikView/converting-month-year/m-p/15947#M785430 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>i have date format like this</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196122_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>i need&nbsp; 2 fileds form the above field</P><P>year and month</P><P>how. anyon please help</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/converting-month-year/m-p/15947#M785430 qlikapple 2020-11-25T16:16:04Z Re: converting month year https://community.qlik.com/t5/QlikView/converting-month-year/m-p/15948#M785431 <HTML><HEAD></HEAD><BODY><P>Month(Timestamp#('17-Sep-2013 08:12:56', 'DD-MMM-YYYY hh:mm:ss'))</P><P></P><P>Year(Timestamp#('17-Sep-2013 08:12:56', 'DD-MMM-YYYY hh:mm:ss'))</P></BODY></HTML> Tue, 13 Mar 2018 07:22:08 GMT https://community.qlik.com/t5/QlikView/converting-month-year/m-p/15948#M785431 sasiparupudi1 2018-03-13T07:22:08Z Re: converting month year https://community.qlik.com/t5/QlikView/converting-month-year/m-p/15949#M785432 <HTML><HEAD></HEAD><BODY><P>=Year(Timestamp(<SPAN style="font-size: 13.3333px;">CREATION_DATE</SPAN>,'DD-MMM-YYYY hh:mm:ss'))</P><P></P><P>=Month(Timestamp(<SPAN style="font-size: 13.3333px;">CREATION_DATE</SPAN>,'DD-MMM-YYYY hh:mm:ss'))</P></BODY></HTML> Tue, 13 Mar 2018 07:54:49 GMT https://community.qlik.com/t5/QlikView/converting-month-year/m-p/15949#M785432 shiveshsingh 2018-03-13T07:54:49Z