topic Max(Date) - 1 ??? in QlikView https://community.qlik.com/t5/QlikView/Max-Date-1/m-p/238508#M89363 <HTML><HEAD></HEAD><BODY><P>Try Max(Date, 2)</P></BODY></HTML> Wed, 11 Nov 2009 21:32:40 GMT disqr_rm 2009-11-11T21:32:40Z Max(Date) - 1 ??? https://community.qlik.com/t5/QlikView/Max-Date-1/m-p/238507#M89362 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm trying to get the 2nd last invoice date. Obviously Max(Date) -1 does not work, it'll give the date before Max(Date) and not the last invoice date. Is there a simple way of getting the last two invoices dates?</P><P>I was thinking of count (Date), display max (count(date)), and display max(count(date))-1... it makes sense in my head, but doesn't translate well in practice.</P><P>Thanks,</P><P>Chhai...</P></BODY></HTML> Wed, 11 Nov 2009 21:29:30 GMT https://community.qlik.com/t5/QlikView/Max-Date-1/m-p/238507#M89362 2009-11-11T21:29:30Z Max(Date) - 1 ??? https://community.qlik.com/t5/QlikView/Max-Date-1/m-p/238508#M89363 <HTML><HEAD></HEAD><BODY><P>Try Max(Date, 2)</P></BODY></HTML> Wed, 11 Nov 2009 21:32:40 GMT https://community.qlik.com/t5/QlikView/Max-Date-1/m-p/238508#M89363 disqr_rm 2009-11-11T21:32:40Z Max(Date) - 1 ??? https://community.qlik.com/t5/QlikView/Max-Date-1/m-p/238509#M89364 <HTML><HEAD></HEAD><BODY><P>You can use the Rank Function for dates .</P></BODY></HTML> Wed, 11 Nov 2009 21:33:46 GMT https://community.qlik.com/t5/QlikView/Max-Date-1/m-p/238509#M89364 2009-11-11T21:33:46Z Max(Date) - 1 ??? https://community.qlik.com/t5/QlikView/Max-Date-1/m-p/238510#M89365 <HTML><HEAD></HEAD><BODY><P>Rakesh,</P><P>nice! I felt like a noob after that! Thank you very much sir.</P><P></P><P>Chhai</P></BODY></HTML> Wed, 11 Nov 2009 21:48:23 GMT https://community.qlik.com/t5/QlikView/Max-Date-1/m-p/238510#M89365 2009-11-11T21:48:23Z