DateBetween with Specified Date

I'm currently trying to create a function where I can take a date, say May 30, 2018 and determine if it's inbetween two dates that are already inputted into a query.    For example:  - Start date ...