topic How to find monthname from monthnumber in QlikView https://community.qlik.com/t5/QlikView/How-to-find-monthname-from-monthnumber/m-p/909196#M652988 <HTML><HEAD></HEAD><BODY><P>Hi Genuises,</P><P></P><P>I have to find the monthname of the month lying two months back from todays date</P><P></P><P>I am using the formula =month(Today())-2), it gives me as 5 but I want this five to be displayed as May.</P><P></P><P>I want all this to be implemented in the script.</P><P></P><P>Thanks,</P><P>Shashank</P></BODY></HTML> Wed, 22 Jul 2015 05:53:57 GMT Anonymous 2015-07-22T05:53:57Z How to find monthname from monthnumber https://community.qlik.com/t5/QlikView/How-to-find-monthname-from-monthnumber/m-p/909196#M652988 <HTML><HEAD></HEAD><BODY><P>Hi Genuises,</P><P></P><P>I have to find the monthname of the month lying two months back from todays date</P><P></P><P>I am using the formula =month(Today())-2), it gives me as 5 but I want this five to be displayed as May.</P><P></P><P>I want all this to be implemented in the script.</P><P></P><P>Thanks,</P><P>Shashank</P></BODY></HTML> Wed, 22 Jul 2015 05:53:57 GMT https://community.qlik.com/t5/QlikView/How-to-find-monthname-from-monthnumber/m-p/909196#M652988 Anonymous 2015-07-22T05:53:57Z Re: How to find monthname from monthnumber https://community.qlik.com/t5/QlikView/How-to-find-monthname-from-monthnumber/m-p/909197#M652989 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P>=Month(Floor(AddMonths(Today(),-2)))</P></BODY></HTML> Wed, 22 Jul 2015 05:58:19 GMT https://community.qlik.com/t5/QlikView/How-to-find-monthname-from-monthnumber/m-p/909197#M652989 MayilVahanan 2015-07-22T05:58:19Z Re: How to find monthname from monthnumber https://community.qlik.com/t5/QlikView/How-to-find-monthname-from-monthnumber/m-p/909198#M652991 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Boss <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Wed, 22 Jul 2015 06:05:55 GMT https://community.qlik.com/t5/QlikView/How-to-find-monthname-from-monthnumber/m-p/909198#M652991 Anonymous 2015-07-22T06:05:55Z Re: How to find monthname from monthnumber https://community.qlik.com/t5/QlikView/How-to-find-monthname-from-monthnumber/m-p/909199#M652992 <HTML><HEAD></HEAD><BODY><P>Month(AddMonths(Today(),-2))</P></BODY></HTML> Wed, 22 Jul 2015 06:06:01 GMT https://community.qlik.com/t5/QlikView/How-to-find-monthname-from-monthnumber/m-p/909199#M652992 sasiparupudi1 2015-07-22T06:06:01Z