topic Re: Max Date in QlikView https://community.qlik.com/t5/QlikView/Max-Date/m-p/1251201#M395947 <HTML><HEAD></HEAD><BODY><P>14:00 AM ?</P></BODY></HTML> Tue, 13 Dec 2016 00:03:22 GMT MarcoWedel 2016-12-13T00:03:22Z Max Date https://community.qlik.com/t5/QlikView/Max-Date/m-p/1251200#M395946 <HTML><HEAD></HEAD><BODY><P>&nbsp; Hi, Can you please tell me how to get max date from the below dateformat??</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="195"><TBODY><TR><TD height="17" width="195">Date</TD></TR><TR><TD class="xl63" height="17">12/13/2016&nbsp; 13:00:00 AM</TD></TR><TR><TD class="xl63" height="17">12/13/2016&nbsp; 14:00:00 AM</TD></TR><TR><TD class="xl63" height="17">12/13/2016&nbsp; 13:00:00 AM</TD></TR><TR><TD class="xl63" height="17">12/13/2016&nbsp; 13:00:00 AM</TD></TR><TR><TD class="xl63" height="17">12/13/2016&nbsp; 13:00:00 AM</TD></TR></TBODY></TABLE><P>Thanks</P></BODY></HTML> Mon, 12 Dec 2016 22:01:08 GMT https://community.qlik.com/t5/QlikView/Max-Date/m-p/1251200#M395946 qlikuser222 2016-12-12T22:01:08Z Re: Max Date https://community.qlik.com/t5/QlikView/Max-Date/m-p/1251201#M395947 <HTML><HEAD></HEAD><BODY><P>14:00 AM ?</P></BODY></HTML> Tue, 13 Dec 2016 00:03:22 GMT https://community.qlik.com/t5/QlikView/Max-Date/m-p/1251201#M395947 MarcoWedel 2016-12-13T00:03:22Z Re: Max Date https://community.qlik.com/t5/QlikView/Max-Date/m-p/1251202#M395948 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>Timestamp(max(num(DateField)))</P></BODY></HTML> Tue, 13 Dec 2016 05:41:22 GMT https://community.qlik.com/t5/QlikView/Max-Date/m-p/1251202#M395948 shraddha_g 2016-12-13T05:41:22Z Re: Max Date https://community.qlik.com/t5/QlikView/Max-Date/m-p/1251203#M395949 <HTML><HEAD></HEAD><BODY><P>None of those times are valid. A time can either be from a 24h clock (13:00, 14:00) or from a 12 hour clock (1:00 PM, 2:00 PM).</P></BODY></HTML> Tue, 13 Dec 2016 05:58:45 GMT https://community.qlik.com/t5/QlikView/Max-Date/m-p/1251203#M395949 jonathandienst 2016-12-13T05:58:45Z