https://community.qlik.com/t5/App-Development/Expression-for-all-dates-less-than-TODAY/m-p/1680452#M51779 <P>You can add a flag field to your mastercalendar in the script that flags all dates that are earlier than today, today and in the future, for example:</P><P>If(DateField &lt; Today(), 'Past',&nbsp;If(DateField = Today(), 'Today', 'Future')) as DateSortFlag</P><P>Add a filter object with the dimension field&nbsp;DateSortFlag to the sheet and users are able to select dates from the past in one click.</P><P>Hope it helps!</P><P>&nbsp;</P> Fri, 28 Feb 2020 15:42:10 GMT TimvB 2020-02-28T15:42:10Z https://community.qlik.com/t5/App-Development/Expression-for-all-dates-less-than-TODAY/m-p/1680017#M51727 <P>Hello,</P><P>&nbsp;</P><P>I am trying to create a button for a sheet to filter for all dates less than TODAY using the 'TODAY' Expression, but have not been successful so far. Any ideas?</P> Thu, 27 Feb 2020 17:03:17 GMT https://community.qlik.com/t5/App-Development/Expression-for-all-dates-less-than-TODAY/m-p/1680017#M51727 jglenn87 2020-02-27T17:03:17Z https://community.qlik.com/t5/App-Development/Expression-for-all-dates-less-than-TODAY/m-p/1680452#M51779 <P>You can add a flag field to your mastercalendar in the script that flags all dates that are earlier than today, today and in the future, for example:</P><P>If(DateField &lt; Today(), 'Past',&nbsp;If(DateField = Today(), 'Today', 'Future')) as DateSortFlag</P><P>Add a filter object with the dimension field&nbsp;DateSortFlag to the sheet and users are able to select dates from the past in one click.</P><P>Hope it helps!</P><P>&nbsp;</P> Fri, 28 Feb 2020 15:42:10 GMT https://community.qlik.com/t5/App-Development/Expression-for-all-dates-less-than-TODAY/m-p/1680452#M51779 TimvB 2020-02-28T15:42:10Z