Use Button & Select in Field to filter sheet by date variable
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.
User inputs date in input box and it is store to variable vFCSDate.
User then clicks on a button to filter just those within the date range.
I created a button and used Select in Field action with this code:
=END_DATE >= $(vFCSDate)-30 and END_DATE <= $(vFCSDate)
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.