How to Filter a View to a date between two dates?

I am working on a solution where people can keep track of team members vacation dates. This part is easy. Essential a table with Person Name, StartDate and Stopdate.

The problem that I am having a problem with is how to craft the filter expression for a view controller to display the people who are on vacation on a specific date.

The use case is that the manager records everyone vacation requests. In the morning the manager wants to see an output that shows only the vacation-bound employees on a specific day (like today).

I am able to replicate the functionality using SQL but from within a filter expression.

What is a good way to implement this functionality

Thank you
1 person has
this question