You are here: Features > Linkage > CLP Codes > Reporting Dates CLP codes

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.

Related Topics