Do you have a workbook you can attach? or maybe some pictures with expected outcome?
In attachment: Order Date is currently filtered on 12/30/2016 (latest date), after publishing this dashboard and scheduled for daily refresh whenever there is a new 'Order Date' poping up in the data (in Database), it has to automatically select the latest date whenever the dashboard opens up for each user
Tableau - Superstore.png 82.3 KB
If only single date is supposed to be selected, you can use below method.
Top 1 of same field.
This sample does not have recent date, but showing the newest date in the database.
Users still can pick up other date.
And you may already know version 10.3 has function of showing latest date with refresh.
Superstore_sampleSSS_SM_10.2.twbx 349.5 KB