Hello everyone,

I have a dataset that tracks clients in residential programs.  This dataset contains begin and end dates.  As shown below, a unique client can move from one program to another.

Client     Program     BEG_DT     END_DT
1234      1122          02/15/20    05/06/20
1234      5656          05/06/20    10/11/20
1234      2323          10/11/20    04/16/22
1234      5656          04/16/22    08/12/22
1234      8282          08/12/22    03/18/23
1234      5656          03/18/23    04/15/24*

I'd like to create a dashboard that will allow the user to view data on clients In-Care as of a user-selected date.  To identify clients In-Care on a given date (e.g., 12/31/23), I would typically define the population using the logic shown below and then produce the desired charts/graphs for that population. 

# In-Care as of 12/31/23 = (BEG_DT <= 12/31/23) AND (END_DT>12/31/23)
         *NOTE: This would capture the example client 1234 as in-care at Program 5656 as of 12/31/23

I'm not sure how to create a date filter that (1) lets the user enter (or select) the date of interest, and (2) compares the entered/selected date to both the begin and end dates to determine which records/rows should be used for the dashboard.  Any thoughts? 

It would also be helpful if I could set a minimum and maximum for the possible date entered/selected, so they are only choosing dates out of the range of data available.  

Thank you! 
Jennifer