Each tab on the Column Header Definition contains fields for adding to your header.
Available Header values and syntax on the Period Information tab are the following:
Header Value |
Header Syntax |
Information Displayed |
Example |
Period Covered |
@COVERED |
Displays the periods covered by the report |
“For the Three Months Ending…” |
Number of Periods Covered |
@PERCOVERED |
Displays a numeric value representing the number of periods covered in the report. |
“2” |
Period End Date: Default |
@ENDING |
Displays the period end date in the date format defined in your Options setting |
“April 30, 2014” |
Period End Date: Prospero Long Date |
@PROSPEROENDING |
Displays the period end date in a long date format but without the day of the week included. |
“April 30, 2014” |
Period End Date: System Long Date |
@LONGENDING |
Displays the period end date in weekday, month, day and year format. |
“Monday, April 30, 2014” |
Period End Date: System Short Date |
@SHORTENDING |
Displays the period end date in MM/DD/YYYY format. |
“4/30/2014” |
Column Period |
@PERIOD |
Displays the column period. |
“April” |
Column Period Number |
@PERNUM |
Displays the column period as a numeric value. |
“4” |
Start Period: Default |
@SPERIOD |
Displays the start period in the date format defined in your Options setting. |
“4/1/2014” |
Start Period: Prospero Long Date |
@PROSPEROSPERIOD |
Displays the start period in a long date format but without the day of the week included. |
“April 1, 2014” |
Start Period: System Long Date |
@LONGSPERIOD |
Displays the period start date in weekday, month, day and year format. |
“Monday, April 1, 2014” |
Start Period: System Short Date |
@SHORTSPERIOD |
Displays the period start date in MM/DD/YYYY format. |
“4/1/2014” |
Column Year |
@YEAR |
Displays the year. |
“2014” |
End Period: Default |
@EPERIOD |
Displays the end period in the date format defined in your Options setting |
“April” |
End Period: Prospero Long Date |
@PROSPEROEPERIOD |
Displays the end period in a long date format but without the day of the week included. |
“April 30, 2014” |
End Period: System Long Date |
@LONGEPERIOD |
Displays the period end date in weekday, month, day and year format. |
“Monday, April 30, 2014” |
End Period: System Short Date |
@SHORTEPERIOD |
Displays the period end date in MM/DD/YYYY format. |
“4/30/2014” |
The selected code(s) will appear in the Current Header field. After making your selection(s), select the OK button to accept the additions.
In addition, refer to the topic on Merged Column Headers.