Period to Date Range
Description
Allows you to take a Period, Fiscal Year, and Century and create a Date or Date Range span for desired output and use - mainly used in variables to set filter ranges.
Calculation Editor
Options
| Input Parameter Values | Input Values |
|---|---|
| Company | Column or Literal Integer |
| Period | Column or Literal Integer |
| Century | Column or Literal Integer |
| Fiscal Year | Column or Literal Integer |
| Side | Both, End, or Start |
| Accounting Interval | 12-Period or 52-Period |
| Relative Offset | Column or Literal |
| Only Rollup If | Generic Criteria |
Remarks
- These period inputs utilize the F0008 Fiscal Date Patterns and F0010 Company Names & Numbers tables to establish the date outputs. In the case of a 52-period calendar, the F0008B table will be used rather than the F0008.
- Leaving the calculation's Company field blank will imply to use the default company's fiscal date pattern for Company 00000. Specifying a literal value number in the company field will force all rows to use that company's date pattern, ex. 00010. Using a table's Company field will then choose the fiscal date pattern per data row record for that company as it relates to that record's fiscal date pattern. If a table does not have a Company field, you will have to create a table lookup or table join to the F0010 table linked by business unit (branch plant).
- Side determines which part of the date range you want returned. Selecting End will return something like <=6/30/2023 while selecting Start would return >=6/1/2023 based on your other inputs. The example below shows what selecting Both would look like.
Example
- Design > Calculations > Period to Date Range
- Input: Period 6, Century 20, Fiscal Year 17, Side Both
- Output: >=6/1/2017:<=6/30/2017