topic Re: Selecting prior and future dates with buttons in QlikView https://community.qlik.com/t5/QlikView/Selecting-prior-and-future-dates-with-buttons/m-p/582322#M1115752 <HTML><HEAD></HEAD><BODY><P>No sooner did I ask than I found the answer.&nbsp; Building the search string returns the prior dates as needed.&nbsp; ='&lt;='&amp;Today()&nbsp;&nbsp; </P></BODY></HTML> Thu, 27 Feb 2014 23:42:44 GMT 2014-02-27T23:42:44Z Selecting prior and future dates with buttons https://community.qlik.com/t5/QlikView/Selecting-prior-and-future-dates-with-buttons/m-p/582321#M1115751 <HTML><HEAD></HEAD><BODY><P>I have imported a field [Meeting Date] which has prior year and future six months data.&nbsp; I want to use a button or other appropriate method to set the dates shown as either all the dates prior to today or all the dates in the future.&nbsp;&nbsp; I am using the Field [Meeting Date] in the Action Select in Field.&nbsp; I haven't found a way to get the Search String to return the results I am looking for.<SPAN style="font-size: 10pt; line-height: 1.5em;"> I can return = Today(),(one date, naturally) but using &lt;= Today() isn't working.&nbsp;&nbsp; I'm very new to QlikView, but have done similar things with other BI tools.&nbsp; I apparently don't understand the way the tool works with scripts.&nbsp; I have seen examples such as ='&lt;=' Today(), but that doesn't return any results and gives me formatting warnings.</SPAN></P></BODY></HTML> Thu, 27 Feb 2014 23:34:21 GMT https://community.qlik.com/t5/QlikView/Selecting-prior-and-future-dates-with-buttons/m-p/582321#M1115751 2014-02-27T23:34:21Z Re: Selecting prior and future dates with buttons https://community.qlik.com/t5/QlikView/Selecting-prior-and-future-dates-with-buttons/m-p/582322#M1115752 <HTML><HEAD></HEAD><BODY><P>No sooner did I ask than I found the answer.&nbsp; Building the search string returns the prior dates as needed.&nbsp; ='&lt;='&amp;Today()&nbsp;&nbsp; </P></BODY></HTML> Thu, 27 Feb 2014 23:42:44 GMT https://community.qlik.com/t5/QlikView/Selecting-prior-and-future-dates-with-buttons/m-p/582322#M1115752 2014-02-27T23:42:44Z