SI.BUDGETABLEPERIODBYDATE
Created by Damien Zwillinger, Modified on Mon, 3 Jun at 6:24 PM by Liubov Kabir
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)
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 |
Examples
Example #1
SI.BUDGETABLEPERIODBYDATE("Sage", "2020-02-01")Description
Returns the budgetable period which contains the date February 1, 2020
Results
Example #2
SI.BUDGETABLEPERIODBYDATE("Sage", F3)Description
Returns the budgetable period which contains the date displayed in cell F3
Results
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