LASTREFRESHDATE

Created by Damien Zwillinger, Modified on Thu, 31 Aug 2023 at 12:08 AM by Damien Zwillinger

Applies to:

Velixo NX
Sage Intacct

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.