I am trying to display a list of all events in the upcoming two weeks. My data looks like this:
- 09/01/2020 Event A
- 27/01/2020 Event B
- 29/01/2020 Event C
- 03/05/2020 Event D
I would like to filter on all events from TODAY until TODAY + 2 weeks. In the example it should only show Event B and C. How to best filter the list of dates? I've tried using the SELECT formula with such a formula:
I've also tried user input control, but I cannot seem to use relative dates in the default value fields.
Any other thoughts?