Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Someone know wich is function to display the date of the last data load in a text box?
I attach the result of what I want to insert in a text box inside the report.
Thanks
This is the function you are looking for:
reloadtime()
Yep. Write =reloadtime() or maybe ='Last reload: ' & reloadtime()
This is what I use and it works perfectly.
='[ Last updated: '& Now(0)&' ]'
Now(0) returns the time at the last finished reload
I would not advise to use the now() function as it is bad for performance. That function results in constantly re-calculating your sheet.
Now() should only constantly recalculate when the timer mode is 1/default, correct?
Thanks!
Yep.
0 is reload time
1 is actual now (recalculating and triggers refresh every second)
2 is document opened time (opened by user)