topic Re: Max of Date in Integration, Extension & APIs https://community.qlik.com/t5/Integration-Extension-APIs/Max-of-Date/m-p/101183#M1412 <HTML><HEAD></HEAD><BODY><P>Try</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Date(Max(Date#(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Field1</SPAN>, 'MMM-YYYY')))</P></BODY></HTML> Fri, 12 Oct 2018 21:22:01 GMT vamsee 2018-10-12T21:22:01Z Max of Date https://community.qlik.com/t5/Integration-Extension-APIs/Max-of-Date/m-p/101181#M1410 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a date field in the format 'JAN-2018', here I want to take the Max of date available. I tried using Max(Field1) but I don't get any output.</P><P></P><P>Any suggestions.</P><P></P><P>Thanks,</P></BODY></HTML> Fri, 12 Oct 2018 17:38:31 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Max-of-Date/m-p/101181#M1410 rxp03570 2018-10-12T17:38:31Z Re: Max of Date https://community.qlik.com/t5/Integration-Extension-APIs/Max-of-Date/m-p/101182#M1411 <HTML><HEAD></HEAD><BODY><P>Did you check the data type of the field in data model viewer? Maybe a data type issue</P></BODY></HTML> Fri, 12 Oct 2018 18:05:37 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Max-of-Date/m-p/101182#M1411 dplr-rn 2018-10-12T18:05:37Z Re: Max of Date https://community.qlik.com/t5/Integration-Extension-APIs/Max-of-Date/m-p/101183#M1412 <HTML><HEAD></HEAD><BODY><P>Try</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Date(Max(Date#(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Field1</SPAN>, 'MMM-YYYY')))</P></BODY></HTML> Fri, 12 Oct 2018 21:22:01 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Max-of-Date/m-p/101183#M1412 vamsee 2018-10-12T21:22:01Z