We currently have a spreadsheet containing a table with data on users of a product. There is a date column showing when each user began using the product as well as a column that holds the date when the user stopped using the product(if they are still using the product the cell in that column is left blank for that user).
We need to set up a way so that in our dashboard view we can present some type of input field or button for the app users to select month and year; this will then filter the data from the user information table to only show users who have either a "blank" value in the column denoting the date they stopped using the product, or that the date in that row of the column is less than the end date of the month selected in the selected year.
This is simple to do with a filter statement and a static date value to filter by, but I'm not sure how we can go about setting this up with the need to dynamically insert an end of month date and a year dynamically chosen by the user via some input element on the dashboard view.
LinkedIn
Twitter
