SI.BUDGETABLEPERIODBYDATE
Created by Damien Zwillinger, Modified on Mon, 30 Sep at 12:18 PM by Harry Lewis
Applies to:
- Velixo NX
- Sage Intacct
The SI.BUDGETABLEPERIODBYDATE function returns the name of a budgetable period that contains the specified date
Syntax
SI.BUDGETABLEPERIODBYDATE(Connection, Date)
Parameters
The SI. BUDGETABLEPERIODBYDATE function uses the following parameters:
Parameter | Required/ Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
Date | Required | The date for which the corresponding budgetable period is to be retrieved (in YYYY-MM-DD format or a cell reference to a date in a valid Excel format) |
Examples
Example 1 - referencing a date in the function
SI.BUDGETABLEPERIODBYDATE("Sage", "2020-02-01")Description
Returns the budgetable period which contains the date February 1, 2020
Results
Example 2 - referencing a date in a cell
SI.BUDGETABLEPERIODBYDATE("Sage", F3)Description
Returns the budgetable period which contains the date displayed in cell F3
Results
(note that the cell containing the date can be in a valid Excel date format)
Example with an Error
Description
If you attempt to access a budgetable period that does not exist within Sage Intacct, a message will appear in the Velixo NX side panel...
... and also be accessible within the cell:
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