Description
The LASTREFRESHDATE function returns an Excel date/time value of when the specified connection was last refreshed.
Syntax
LASTREFRESHDATE(Connection)
The LASTREFRESHDATE function uses the following parameters:
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
Example
=LASTREFRESHDATE("Demo")Description
Returns the Excel date value for when the Demo connection was last refreshed.
Result
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.  |