I’m trying to find an exact timestamp for a query to find exactly when a datapoint was updated in my database yesterday (No way to retrieve this otherwise).
By using version history I can narrow it down to a 20 minute period between refreshes, however I can’t be sure that the auto-save time corresponds with the refresh time.
When I look at the information for a query refreshed today, I can see the time-stamp so I am thinking that this information must be stored somewhere?
Alternatively, would there be a way to see when the table-object was updated? This could act as a proxy for the query refresh.
Any suggestions would be greatly appreciated 🙂 Thanks!
Query 1 – Refreshed Yesterday, Query 2 – Refreshed Today
I’ve looked for solutions, and only found advice that suggests adding a reference that takes Date.TodayNow() at the same time as the query refresh. This will be helpful going forward but does not allow me to access historical refresh date-times.
Tas Man is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.