Date Filter Automatically Update to latest date in Table

Hello everybody, I have a date filter in my model that is derrived from a date table. Is there a way I can have this filter automatically select the latest day without manual intervention? I tried adding a colum to add a "1" next to the latestdate in the data and applying a filter of 1 to the filter, but this did not work. Any suggestions?