How can I get the rows in a table where today's date is between (inclusive) two DATE columns of that row?
For example, take these two columns of a table:

![enter image description here](https://i.stack.imgur.com/vVe8M.png)

How could I get the first and second rows on the 10th of April, or the 3rd row on the 25th (inclusive, like I said)?

Any help would be greatly appreciated. Thanks in advance!