I used the insert function in my dashboard title as below to give the data update time:
This works fine but I have 2 issues:
1) I am only interested in the date update date, not the time
2) I publish the workbook to a server, when you open the dashboard through the server it updates the time to when you opened the server version, not the time the data was updated?
Is there a smarter way i can get a date added, but that does not update through the server?
Our DB Team Creates extra column in DB called date updated
I use that column--> take the max of that --> use it in a title
1) you can show any format you can
2) It will show exact when your data updated
Hope this helps kindly mark this answer as correct/helpful so that it will be helpful to others