topic Re: formating month in QlikView https://community.qlik.com/t5/QlikView/formating-month/m-p/47053#M605672 <HTML><HEAD></HEAD><BODY><P>Date(AddMonths(Date#('05','MM'),-1),'MM')</P></BODY></HTML> Tue, 17 Apr 2018 09:51:01 GMT sasiparupudi1 2018-04-17T09:51:01Z formating month https://community.qlik.com/t5/QlikView/formating-month/m-p/47052#M605671 <HTML><HEAD></HEAD><BODY><P>HELLO</P><P>HOW TO EXTRACT&nbsp; THE PREVIOUS MONTH TO DATE&nbsp; IN THIS FORMAT 05 04 03 02 ....</P><P></P><P>thank you</P></BODY></HTML> Tue, 17 Apr 2018 09:46:47 GMT https://community.qlik.com/t5/QlikView/formating-month/m-p/47052#M605671 souadouert 2018-04-17T09:46:47Z Re: formating month https://community.qlik.com/t5/QlikView/formating-month/m-p/47053#M605672 <HTML><HEAD></HEAD><BODY><P>Date(AddMonths(Date#('05','MM'),-1),'MM')</P></BODY></HTML> Tue, 17 Apr 2018 09:51:01 GMT https://community.qlik.com/t5/QlikView/formating-month/m-p/47053#M605672 sasiparupudi1 2018-04-17T09:51:01Z Re: formating month https://community.qlik.com/t5/QlikView/formating-month/m-p/47054#M605673 <HTML><HEAD></HEAD><BODY><P>What is your date field format ?</P></BODY></HTML> Tue, 17 Apr 2018 10:06:11 GMT https://community.qlik.com/t5/QlikView/formating-month/m-p/47054#M605673 YoussefBelloum 2018-04-17T10:06:11Z