LASTREFRESHDATE function

Created by Harry Lewis, Modified on Thu, 05 Oct 2023 at 05:50 PM by Gabriel Michaud

Applies to:

Velixo Classic
ERP: Acumatica, CEGID, Haufe x360, JAMIS Prime, MYOB Advanced

Description

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

TABLE OF CONTENTS

Syntax
Parameter
Example

Syntax

LASTREFRESHDATE(Connection)

Parameter

The LASTREFRESHDATE function uses the following parameter:

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.