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?

reddit.com
u/Significant-Army-502 — 3 days ago

Question about errands (USA)

I need to pay somebody to drive to a couple of stores, buy some items and ship them to me. Can I do this on TaskRabbit? I'm not sure how I would give the Tasker the money to purchase the items (as one of the shops does not have click and collect or online ordering). Then I would need to also pay them for the shipping.

reddit.com
u/Significant-Army-502 — 1 month ago

Where can I find this wire?

My new reverse cam is missing the circled wire (red one with the black end)

Any idea where I can order it?

Place I ordered it from is beyond useless

u/Significant-Army-502 — 2 months ago

Would like to go to the Leeds game with my auntie, we're not members so not sure if it'll be possible to get a ticket. I think I saw tickets for the Brighton game went into general sale but nothing showing for Leeds, would it be just a couple of days before if at all?

reddit.com
u/Significant-Army-502 — 4 months ago