I need to put a report date on a dashboard and I am running into a problem where Today() or Now() do not update to the current date or time when the dashboard is opened on Tableau Server. The date or time that shows is the value that was true when the dashboard was published to the server. I can update the data by clicking the refresh button but it only updates the data for my current session. As soon as I log out it reverts back to the published value. I have attached a simple workbook to illustrate the problem. Is there a way that the Today() and Now() functions will show the current value at the time the dashboard is opened in tableau server?

Thanks

Frank