How do I select specific rows in a data set based on a single variable date filter?

We have products that move through different status. As they move through these status a new row is generated in the data set (see example below) with the product name, the new status, the date the status started and end status date (set to 1/1/2050). The end date of the previous status is also updated. As a user, I want to enter a date and find out what status each product was in. The logic to calculate the correct status would be where selected filter date >= MAX(status started) and filter date < = MIN(end status date). For example using the -date below and filter date of 11/30/2023 would return

Boots - available

Sandals - available

Sneakers - out of stock

Pumps - discontinued

How would this be accomplished using DOMO?

Thank you