topic Re: Select Date in a column in QlikView https://community.qlik.com/t5/QlikView/Select-Date-in-a-column/m-p/422097#M1164558 <HTML><HEAD></HEAD><BODY><P>Gysbert, thanks for this! it headed me in the right direction... I ended up using this:</P><P></P><P>=FirstSortedValue(DISTINCT [Date],-[Date],2)</P></BODY></HTML> Wed, 17 Oct 2012 09:36:05 GMT 2012-10-17T09:36:05Z Select Date in a column https://community.qlik.com/t5/QlikView/Select-Date-in-a-column/m-p/422095#M1164556 <HTML><HEAD></HEAD><BODY><P>Hi all, please help if you can</P><P></P><P>I need a way to find the second highest value in a date range.</P><P></P><P>So if this is the Table</P><P></P><P>Date</P><P>17/10/2012</P><P>14/10/2012</P><P>13/10/2012</P><P>11/10/2012</P><P>05/10/2012</P><P></P><P>I would want the formula to return 14/10/2012...</P><P></P><P>I might be over thinking this but I am not sure how to do this..</P><P></P><P>Thanks</P></BODY></HTML> Wed, 17 Oct 2012 09:02:02 GMT https://community.qlik.com/t5/QlikView/Select-Date-in-a-column/m-p/422095#M1164556 2012-10-17T09:02:02Z Re: Select Date in a column https://community.qlik.com/t5/QlikView/Select-Date-in-a-column/m-p/422096#M1164557 <HTML><HEAD></HEAD><BODY><P>Try this: =date(FirstSortedValue( [Date],-[Date],2),'DD/MM/YYYY')</P><P>Also make sure your date is really a date and not text. Use the date# function if necessary.</P></BODY></HTML> Wed, 17 Oct 2012 09:15:57 GMT https://community.qlik.com/t5/QlikView/Select-Date-in-a-column/m-p/422096#M1164557 Gysbert_Wassenaar 2012-10-17T09:15:57Z Re: Select Date in a column https://community.qlik.com/t5/QlikView/Select-Date-in-a-column/m-p/422097#M1164558 <HTML><HEAD></HEAD><BODY><P>Gysbert, thanks for this! it headed me in the right direction... I ended up using this:</P><P></P><P>=FirstSortedValue(DISTINCT [Date],-[Date],2)</P></BODY></HTML> Wed, 17 Oct 2012 09:36:05 GMT https://community.qlik.com/t5/QlikView/Select-Date-in-a-column/m-p/422097#M1164558 2012-10-17T09:36:05Z