The LASTREFRESHDATE function returns an Excel date/time value of when the specified connection was last refreshed.
The LASTREFRESHDATE function uses the following parameters:
The name of the connection as configured in the Connection Manager
Returns the Excel date value for when the Demo connection was last refreshed.
Note that the results are returned as a serial number - to match Excel's default treatment for dates. The cell can be formatted to any date format desired.