topic Re: Max(Month) not working in QlikView https://community.qlik.com/t5/QlikView/Max-Month-not-working/m-p/22977#M783939 <HTML><HEAD></HEAD><BODY><P>May be try like this</P><P></P><P>Month(Max(Date))</P><P>Month(AddMonths(Max(Date), -1))</P></BODY></HTML> Wed, 14 Mar 2018 02:06:05 GMT sunny_talwar 2018-03-14T02:06:05Z Max(Month) not working https://community.qlik.com/t5/QlikView/Max-Month-not-working/m-p/22976#M783938 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Can any one please help me on below issue.</P><P>I have date field like below.</P><P>I have extracted Month as </P><P>Month(CreateDate) as Month;</P><P></P><P>when I have taken Max(Month) and Max(Month)-1 on text boxes getting 12,11 instead of Dec and Nov.</P><P>I have tried </P><P>Text(Month(CreatedDate)) as Month; but still not working.</P><P></P><P>Please help me to get month in Dec format.</P><P><IMG alt="created date.png" class="jive-image image-1" src="/legacyfs/online/196257_created date.png" style="height: auto;" /></P><P>Thanks in advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Max-Month-not-working/m-p/22976#M783938 bhavvibudagam 2020-11-25T16:16:04Z Re: Max(Month) not working https://community.qlik.com/t5/QlikView/Max-Month-not-working/m-p/22977#M783939 <HTML><HEAD></HEAD><BODY><P>May be try like this</P><P></P><P>Month(Max(Date))</P><P>Month(AddMonths(Max(Date), -1))</P></BODY></HTML> Wed, 14 Mar 2018 02:06:05 GMT https://community.qlik.com/t5/QlikView/Max-Month-not-working/m-p/22977#M783939 sunny_talwar 2018-03-14T02:06:05Z