topic Month Function in QlikView https://community.qlik.com/t5/QlikView/Month-Function/m-p/1331566#M823522 <HTML><HEAD></HEAD><BODY><P>hi All,</P><P></P><P>I need to store a value in the variable of last month in this format '07/17'</P><P></P><P>Month(Today()) gives value as Aug</P><P>Month(today())-1 gives value as 07</P><P>but I need the output as 07/17</P><P></P><P>please advise</P><P></P><P>thanks in advance</P><P>Sukhwant</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Month Function https://community.qlik.com/t5/QlikView/Month-Function/m-p/1331566#M823522 <HTML><HEAD></HEAD><BODY><P>hi All,</P><P></P><P>I need to store a value in the variable of last month in this format '07/17'</P><P></P><P>Month(Today()) gives value as Aug</P><P>Month(today())-1 gives value as 07</P><P>but I need the output as 07/17</P><P></P><P>please advise</P><P></P><P>thanks in advance</P><P>Sukhwant</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Month-Function/m-p/1331566#M823522 2020-11-25T16:16:04Z Re: Month Function https://community.qlik.com/t5/QlikView/Month-Function/m-p/1331567#M823523 <HTML><HEAD></HEAD><BODY><P>May be this</P><P><STRONG>Date(MonthStart(Today()), 'MM/YY')</STRONG></P></BODY></HTML> Tue, 01 Aug 2017 18:17:56 GMT https://community.qlik.com/t5/QlikView/Month-Function/m-p/1331567#M823523 sunny_talwar 2017-08-01T18:17:56Z Re: Month Function https://community.qlik.com/t5/QlikView/Month-Function/m-p/1331568#M823524 <HTML><HEAD></HEAD><BODY><P>=num(Month(today())-1,'00')&amp;'/'&amp;right(Year(Today()),2)</P></BODY></HTML> Tue, 01 Aug 2017 18:18:38 GMT https://community.qlik.com/t5/QlikView/Month-Function/m-p/1331568#M823524 Frank_Hartmann 2017-08-01T18:18:38Z