topic Choose last but one date in App Development https://community.qlik.com/t5/App-Development/Choose-last-but-one-date/m-p/1230105#M24010 <HTML><HEAD></HEAD><BODY><P>Hi community,</P><P>short question about dates: how could I choose the last but one date from a group of date?</P><P>The formula I need is something like</P><P></P><P>today()-LastButOneDate()</P><P></P><P>Thanks in advance!</P></BODY></HTML> Fri, 23 Dec 2016 10:03:30 GMT simotrab 2016-12-23T10:03:30Z Choose last but one date https://community.qlik.com/t5/App-Development/Choose-last-but-one-date/m-p/1230105#M24010 <HTML><HEAD></HEAD><BODY><P>Hi community,</P><P>short question about dates: how could I choose the last but one date from a group of date?</P><P>The formula I need is something like</P><P></P><P>today()-LastButOneDate()</P><P></P><P>Thanks in advance!</P></BODY></HTML> Fri, 23 Dec 2016 10:03:30 GMT https://community.qlik.com/t5/App-Development/Choose-last-but-one-date/m-p/1230105#M24010 simotrab 2016-12-23T10:03:30Z Re: Choose last but one date https://community.qlik.com/t5/App-Development/Choose-last-but-one-date/m-p/1230106#M24011 <HTML><HEAD></HEAD><BODY><P>Perhaps like this: Today() - Max(YourDateFieldHere, 2)</P></BODY></HTML> Fri, 23 Dec 2016 10:04:43 GMT https://community.qlik.com/t5/App-Development/Choose-last-but-one-date/m-p/1230106#M24011 Gysbert_Wassenaar 2016-12-23T10:04:43Z Re: Choose last but one date https://community.qlik.com/t5/App-Development/Choose-last-but-one-date/m-p/1230107#M24012 <HTML><HEAD></HEAD><BODY><P>Thanks a lot!</P></BODY></HTML> Fri, 23 Dec 2016 10:09:44 GMT https://community.qlik.com/t5/App-Development/Choose-last-but-one-date/m-p/1230107#M24012 simotrab 2016-12-23T10:09:44Z