topic Re: Week to Month in QlikView https://community.qlik.com/t5/QlikView/Week-to-Month/m-p/1151957#M906517 <HTML><HEAD></HEAD><BODY><P>solved! Date(MakeWeekDate(Left(week,4),Right(week,2)),'YYYYMMM')</P></BODY></HTML> Mon, 20 Jun 2016 11:45:35 GMT diego_vazquez 2016-06-20T11:45:35Z Week to Month https://community.qlik.com/t5/QlikView/Week-to-Month/m-p/1151956#M906516 <HTML><HEAD></HEAD><BODY><P>Hello everyone.</P><P>I have a field that shows a date in this format: '201625' </P><P>This is the year and the week concatenated.</P><P>My problem is that I have to extract the month from that field and I don't know how.</P><P>All the help in that subject would be apreciated.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Week-to-Month/m-p/1151956#M906516 diego_vazquez 2020-11-25T16:16:04Z Re: Week to Month https://community.qlik.com/t5/QlikView/Week-to-Month/m-p/1151957#M906517 <HTML><HEAD></HEAD><BODY><P>solved! Date(MakeWeekDate(Left(week,4),Right(week,2)),'YYYYMMM')</P></BODY></HTML> Mon, 20 Jun 2016 11:45:35 GMT https://community.qlik.com/t5/QlikView/Week-to-Month/m-p/1151957#M906517 diego_vazquez 2016-06-20T11:45:35Z