Formatting calendar hierarchy levels

You can format the period labels for calendar hierarchy levels.
Note: 
  • The labeling year is the planning year specified in the Year Definition field on the Calendar page.
  • The format definition is a text string. These rules apply:
    • All characters are permitted except £$^&*()"“”. The % character is permitted only as the prefix of a variable.
    • Variables have the % character as a prefix.
The hierarchy level formats and variables:
Format Date part (level) Permitted level Usage Description Example
%yy Year All

Last two digits of the Planning year based on the Year Definition.

17
%yyyy Year All Four-digit number from the Planning year defined by the Year Definition. 2017
%cyy Year All Last two digits of the calendar year represented by the current period date. The first or last date of the period is considered based on the Year Definition. 17
%cyyy Year All Four-digit number from the calendar year represented by the current period date. Uses the first or last date of the period depending on the Year Definition. 2017
%q Quarter Quarter, Month, Week, Part week, Day One-digit number that represents the quarter of the planning year. 1
%mm Month Month, Week, Part week, Day Two-digit number, with a leading zero that represents the month of the planning year. 07
%cmm Month Month, Week, Part week, Day Two-digit number (with leading zero) of the calendar month represented by the current period date. The first or last date of the period is considered based on the Year Definition. 07
%cmmm Month Month, Week, Part week, Day Three letter code from the calendar month represented by the current period date. Uses the first or last date of the period depending on Year Definition. Jul
%ww Week Week, Part Week, Day Two-digit number, with a leading zero that represents the week in the planning year. 26
%pw Part- Week Part Week, Day A single character that represents the part week split for the weekly period and the corresponding calendar month. Possible values:
  • A: The week fits entirely into 1 calendar month and is represented by 1 part-week.
  • A & B: The week is split between 2 calendar months and is represented by 2 part-weeks.
Note: This is applicable only when the Enabled part-week check box is selected.
A
%dy Day Day Three-digit number that represents the day of the planning year, with leading zeros. This is derived from the First Month/Week of the year and First Day of Month values. 183
%dw Day Day Two-digit number that represents the day of the month, with leading zeros. This must be used with %dy, %ww, %mm, %cmm or %cmmm Monday
%dd Day Day Two-digit number, with leading zero that represents the day of the month. This is derived from the actual date of the month and must be used with %dy, %ww, %mm, %cmm or %cmmm to ensure uniqueness. 01
%scd Day All Two-digit number that represents the day of the calendar month when the bucket starts. 01
%scmm Month All Two-digit number, with a leading zero that represents the calendar month, to which the bucket start date belongs. 03
%scmmm Month All Three-letter code that represents the calendar month, to which the bucket start date belongs Mar
%scyy Year All Two-digit number that represents the calendar year to which the bucket start date belongs. 20
%scyyyy Year All Four-digit number that represents the calendar year to which the bucket start date belongs. 2020
%ecd Day All Two-digit number that represents the day of the calendar month when the bucket ends. 31
%ecmm Month All Two-digit number, with a leading zero that represents the calendar month to which the bucket start date belongs. 03
%ecmmm Month All Three-letter code that represents the calendar month to which the bucket end date belongs. Mar
%ecyy Year All Two-digit number that represents the calendar year, to which the bucket end date belongs. 20
%ecyyyy Year All Four-digit number that represents the calendar year to which the bucket end date belongs. 2020
Note: You cannot use lower-level variables in higher-level formats. For example, you cannot use months in the year format, but you can use years in the month format.

If the Year Definition is set to Year of Last Month, for a year starting in April 2018 and ending in March 2019, April 2018 is the first planning month of planning year 2019. To create a label FY19 M01 for this month, use the format FY%yy M%mm".