https://community.qlik.com/t5/QlikView/Convert-various-string-dates-to-a-Year-and-Month-column/m-p/1558271#M599096 <P>Hi all,</P><P>I've got a table in which there is a column known as Period. It describes the year and month as, for example, 1998MM02. In addition, it also has the row 1998JJ00, which in this case is the overall year accumulation. A brief example below:</P><PRE>Period 1998MM01 1998MM02 1998MM03 1998MM04 1998MM05 1998MM06 1998MM07 1998MM08 1998MM09 1998MM10 1998MM11 1998MM12 1998JJ00</PRE><P>What I want is two separate columns, one that contains the Year and another containing the Month.&nbsp; So far, I managed to remove the characters from the Period column, and managed to separate it into two additional columns Year and Month. However, the year accumulation (i.e. 1998JJ00) is in both columns NaN ( - ).&nbsp;</P><P>What is a simple solution to get the output given below ?</P><PRE>Period Year Month 1998MM01 1998 01 1998MM02 1998 02 1998MM03 1998 03 1998MM04 1998 04 1998MM05 ..... ... 1998MM06 1998MM07 1998MM08 1998MM09 1998MM10 1998MM11 1998MM12 1998 12 1998JJ00 1998 00</PRE><P>Thanks in advance!</P> Sat, 16 Nov 2024 04:07:21 GMT klikgevoel 2024-11-16T04:07:21Z https://community.qlik.com/t5/QlikView/Convert-various-string-dates-to-a-Year-and-Month-column/m-p/1558271#M599096 <P>Hi all,</P><P>I've got a table in which there is a column known as Period. It describes the year and month as, for example, 1998MM02. In addition, it also has the row 1998JJ00, which in this case is the overall year accumulation. A brief example below:</P><PRE>Period 1998MM01 1998MM02 1998MM03 1998MM04 1998MM05 1998MM06 1998MM07 1998MM08 1998MM09 1998MM10 1998MM11 1998MM12 1998JJ00</PRE><P>What I want is two separate columns, one that contains the Year and another containing the Month.&nbsp; So far, I managed to remove the characters from the Period column, and managed to separate it into two additional columns Year and Month. However, the year accumulation (i.e. 1998JJ00) is in both columns NaN ( - ).&nbsp;</P><P>What is a simple solution to get the output given below ?</P><PRE>Period Year Month 1998MM01 1998 01 1998MM02 1998 02 1998MM03 1998 03 1998MM04 1998 04 1998MM05 ..... ... 1998MM06 1998MM07 1998MM08 1998MM09 1998MM10 1998MM11 1998MM12 1998 12 1998JJ00 1998 00</PRE><P>Thanks in advance!</P> Sat, 16 Nov 2024 04:07:21 GMT https://community.qlik.com/t5/QlikView/Convert-various-string-dates-to-a-Year-and-Month-column/m-p/1558271#M599096 klikgevoel 2024-11-16T04:07:21Z https://community.qlik.com/t5/QlikView/Convert-various-string-dates-to-a-Year-and-Month-column/m-p/1558275#M599099 <P>For Month : =Right(Period,'2')<BR />For Year : =left(Period,4) OR subField(Period,'MM')<BR /><BR /></P> Tue, 19 Mar 2019 08:44:46 GMT https://community.qlik.com/t5/QlikView/Convert-various-string-dates-to-a-Year-and-Month-column/m-p/1558275#M599099 Shubham_Deshmukh 2019-03-19T08:44:46Z