topic Use Button & Select in Field to filter sheet by date variable in QlikView https://community.qlik.com/t5/QlikView/Use-Button-Select-in-Field-to-filter-sheet-by-date-variable/m-p/322827#M586507 <HTML><HEAD></HEAD><BODY><OL><LI> I would like the end user to be able to click on a button to filter the select to only those contracts ending in a date range based on filter. </LI><LI>User inputs date in input box and it is store to variable vFCSDate. </LI><LI>User then clicks on a button to filter just those within the date range. <OL><LI>I created a button and used Select in Field action with this code:</LI><LI><P>=END_DATE &gt;= $(vFCSDate)-30 and END_DATE &lt;= $(vFCSDate) </P></LI></OL></LI><LI>I am trying to find a way for uer to input an FCS Date and trigger the sheet to filter only to those contracts with end date in the 30 day range before the FCS date.</LI></OL></BODY></HTML> Mon, 01 Aug 2011 20:46:14 GMT 2011-08-01T20:46:14Z Use Button & Select in Field to filter sheet by date variable https://community.qlik.com/t5/QlikView/Use-Button-Select-in-Field-to-filter-sheet-by-date-variable/m-p/322827#M586507 <HTML><HEAD></HEAD><BODY><OL><LI> I would like the end user to be able to click on a button to filter the select to only those contracts ending in a date range based on filter. </LI><LI>User inputs date in input box and it is store to variable vFCSDate. </LI><LI>User then clicks on a button to filter just those within the date range. <OL><LI>I created a button and used Select in Field action with this code:</LI><LI><P>=END_DATE &gt;= $(vFCSDate)-30 and END_DATE &lt;= $(vFCSDate) </P></LI></OL></LI><LI>I am trying to find a way for uer to input an FCS Date and trigger the sheet to filter only to those contracts with end date in the 30 day range before the FCS date.</LI></OL></BODY></HTML> Mon, 01 Aug 2011 20:46:14 GMT https://community.qlik.com/t5/QlikView/Use-Button-Select-in-Field-to-filter-sheet-by-date-variable/m-p/322827#M586507 2011-08-01T20:46:14Z