LASTREFRESHDATE function
Created by Harry Lewis, Modified on Thu, 1 Aug at 4:41 PM by Harry Lewis
Applies to:
- Velixo Classic
- ERP: Acumatica, CEGID, Haufe x360, JAMIS Prime, MYOB Acumatica
Description
The LASTREFRESHDATE function returns an Excel date/time value of when the specified connection was last refreshed.
With Velixo NX, please see the WORKBOOKLASTREFRESHDATE function.
TABLE OF CONTENTS
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
![refreshdate_default.png](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000158653/original/tKuZluxt0740QRc_AAHf9d8iGNoS5mOGDQ.png?1694128513)
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. ![]() |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article