How to display the date of the last data load in a text box?

[davdiste]

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

[oknotsen]

This is the function you are looking for:

reloadtime()

[Anonymous]

Yep. Write =reloadtime() or maybe ='Last reload: ' & reloadtime()

[#4]

This is what I use and it works perfectly.

='[ Last updated: '& Now(0)&' ]'

Now(0) returns the time at the last finished reload

[oknotsen]

I would not advise to use the now() function as it is bad for performance. That function results in constantly re-calculating your sheet.

[#6]

Now() should only constantly recalculate when the timer mode is 1/default, correct? 

[davdiste]

Thanks!

[Anonymous]

Yep.

0 is reload time

1 is actual now (recalculating and triggers refresh every second)

2 is document opened time (opened by user)