topic Re: Max date &lt;= today in QlikView https://community.qlik.com/t5/QlikView/Max-date-lt-today/m-p/992367#M338057 <HTML><HEAD></HEAD><BODY><P>Hi Tamil</P><P></P><P>thanks but it seems not to work... </P><P>If I put expression in a listbox I get '-'</P></BODY></HTML> Thu, 29 Oct 2015 16:04:38 GMT 2015-10-29T16:04:38Z Max date <= today https://community.qlik.com/t5/QlikView/Max-date-lt-today/m-p/992366#M338056 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I'm trying to define a variable setting Max date lower than today.</P><P></P><P>Max date works with this formula</P><P></P><P>=max({&lt;INFOCUBE={P_ORDR_3}&gt;}&nbsp; SID_0CALDAY.DATE0)</P><P></P><P>but I need to add "&lt;= today"</P><P></P><P><SPAN style="font-size: 13.3333px;">SID_0CALDAY.DATE0 format is dd.mm.yyyy</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">thanks and regards<BR /></SPAN></P></BODY></HTML> Thu, 29 Oct 2015 14:59:48 GMT https://community.qlik.com/t5/QlikView/Max-date-lt-today/m-p/992366#M338056 2015-10-29T14:59:48Z Re: Max date <= today https://community.qlik.com/t5/QlikView/Max-date-lt-today/m-p/992367#M338057 <HTML><HEAD></HEAD><BODY><P>Hi Tamil</P><P></P><P>thanks but it seems not to work... </P><P>If I put expression in a listbox I get '-'</P></BODY></HTML> Thu, 29 Oct 2015 16:04:38 GMT https://community.qlik.com/t5/QlikView/Max-date-lt-today/m-p/992367#M338057 2015-10-29T16:04:38Z Re: Max date <= today https://community.qlik.com/t5/QlikView/Max-date-lt-today/m-p/992368#M338058 <HTML><HEAD></HEAD><BODY><P><EM>Hi Andrea,</EM></P><P><EM style="line-height: 1.5em; font-size: 10pt;"><BR /></EM></P><P><EM style="line-height: 1.5em; font-size: 10pt;">Sorry for the late reply.. It was very hard to type in mobile.</EM></P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><EM>Firstsortedvalue({&lt;INFOCUBE={'P_ORDR_3'},SID_0CALDAY.DATE0={"&lt;=$(=Date(today(),'DD.MM.YYYY'))"}&gt;}SID_0CALDAY.DATE0,-SID_0CALDAY.DATE0)</EM></SPAN></P></BODY></HTML> Thu, 29 Oct 2015 16:42:19 GMT https://community.qlik.com/t5/QlikView/Max-date-lt-today/m-p/992368#M338058 tamilarasu 2015-10-29T16:42:19Z