https://community.qlik.com/t5/QlikView/Min-and-max-with-the-Format-Jan-2021/m-p/1883681#M1216959 <P>convert to date then take max(field1)</P> <P>date(Date#(field,'MMM-YY'),'MMM-YY') as field1</P> Fri, 21 Jan 2022 07:05:32 GMT anat 2022-01-21T07:05:32Z https://community.qlik.com/t5/QlikView/Min-and-max-with-the-Format-Jan-2021/m-p/1883673#M1216958 <P>Hello All,</P> <P>Could you please help with the below scenario</P> <P>I have a month filed with the values Jan-2021,Feb-2021,..... Jan 2022</P> <P>I am facing challenges&nbsp; in formatting in taking minimum and maximum month&nbsp; year.</P> <P>Could anyone suggest a right way ?</P> <P>&nbsp;</P> Fri, 21 Jan 2022 06:53:01 GMT https://community.qlik.com/t5/QlikView/Min-and-max-with-the-Format-Jan-2021/m-p/1883673#M1216958 Prabhu1204 2022-01-21T06:53:01Z https://community.qlik.com/t5/QlikView/Min-and-max-with-the-Format-Jan-2021/m-p/1883681#M1216959 <P>convert to date then take max(field1)</P> <P>date(Date#(field,'MMM-YY'),'MMM-YY') as field1</P> Fri, 21 Jan 2022 07:05:32 GMT https://community.qlik.com/t5/QlikView/Min-and-max-with-the-Format-Jan-2021/m-p/1883681#M1216959 anat 2022-01-21T07:05:32Z https://community.qlik.com/t5/QlikView/Min-and-max-with-the-Format-Jan-2021/m-p/1883702#M1216960 <P>Thank you.. it worked</P> Fri, 21 Jan 2022 08:12:25 GMT https://community.qlik.com/t5/QlikView/Min-and-max-with-the-Format-Jan-2021/m-p/1883702#M1216960 Prabhu1204 2022-01-21T08:12:25Z