LASTREFRESHDATE function

Overview

The LASTREFRESHDATE function returns an Excel date/time value of when the specified connection was last refreshed.

With Velixo NX, please see the WORKBOOKLASTREFRESHDATEfunction.

CODE

=LASTREFRESHDATE(Connection)

The LASTREFRESHDATE function uses the following argument:

Argument	Required/Optional	Description
`Connection`	Required	The name of the connection as configured in the Connection Manager

CODE

=LASTREFRESHDATE("Demo")

Description:

Returns the Excel date value for when the Demo connection was last refreshed.

Result:

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.