Returns the period start date for the selected period.
Parameter | Description |
---|---|
Period Name | The period name as configured in Oracle. This parameter must be entered in exactly the same format as the period names in Oracle. For example if your period names are configured as follows “Jan-07” in Oracle and you enter “Jan-2007” or “January-07” or “jan-07” for this parameter, GL Wand will not return any data, and will instead return an Error (Period) message. |
Book | Optionally enter a set of books / ledger id to bind the formula to a specific set of books / ledger. If this parameter is omitted, the set of books currently selected in the Set of Books dropdown list will be used. |
Example: =GLW_Period_Start_Date("Jan-02")