Reporting Dates CLP Codes
Field | CLP code |
---|---|
Year End Date | CLP13 |
Year Begin Date | CLP62 |
Current Period Date Sequence | CLP17 |
Current Active Period | CLP22 |
Reporting Period Date Sequences
Field | CLP code |
---|---|
13 Periods | CLP151 |
Monthly | CLP152 |
Bi-Monthly | CLP153 |
Compute bi-monthly balances from | CLP163 |
Quarterly | CLP154 |
Compute quarterly balances from | CLP164 |
Thirdly | CLP155 |
Compute thirdly balances from | CLP165 |
Semi-Annual | CLP156 |
Compute semi-annual balances from | CLP166 |
Yearly | CLP157 |
Compute yearly balances from | CLP167 |
Random | CLP158 |
Note: CLP22 entered on its own will return only the number of the current active period. It will not return the beginning or ending dates of that month. To return the beginning or ending dates of the current active month, use the calculation in Example 2 under the CHOOSE function.