Filtering records based on a user specified date that falls between start date and end date fields

[bethanyweisberg]

Without creating a derived table, is there a way to filter records in Lookml based on a user-specified date which falls between a start date field and end date field?

For example, a user chooses the date 4/01/2024, so it would filter records where the start date field is on or before 4/01/2024 and the end date field is on or after 4/01/2024? Any help is much appreciated! 🙂