Forum Discussion
HELP: Creating a dynamic filter that "ignores" data based on date.
- 8 years ago
You could add a column to your data that has something like this:
Column 1 = date(year(now()),month(now()),day(now())+2)
That will return 2 days in the future from whatever the current date is.
Then add one more column, that compares Column 1 with the Date column in your data. Like:
Filter Column = DATE >= Column 1
That will return TRUE or FALSE.
Then just filter your data for the ones that return TRUE from the Filter Column.
Sorry, DATE should be the column in your data that has the datestamp on it.
So I don't know what it's named in your data (I just put 'DATE' in as a placeholder)- but it should be the column that has the date you want to apply this filter to.
Do I make sense?
Hi Mmace1,
Yes, this makes sense, I am just trying to work it out now.