0 Replies Latest reply: Aug 1, 2011 4:46 PM by Debbie Pyykkonen RSS

    Use Button & Select in Field to filter sheet by date variable

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

      4. 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.