SP List: How to calculate whether todays date is between two columns
I have two date columns
| From Date | To Date |
|---|---|
| 17/08 | 20/08 |
| 23/08 | 29/08 |
What I would like to do is to be able to filter the list to show me only rows where "today" is either on or between the two dates.
So using todays date, for example, it would only show me the first row.
I figured I could create a calculated column and then filter based from that, but I am hitting a brick wall on writing the formula.
In plain text it would just be:
If today is greater or equal to "from date" and less than or equal to "to date"
Any advice?