Calendar period labels for start and end date of bucket

Additional variables are now supported for creating calendar period labels within calendar hierarchy levels, relative to the period start or end date. This functionality allows visualization of planning periods by start or end date in addition to a day, week or month index. For example, FY20 12-AUG

These formats are added:

  • %scd: A two -digit number representing the day of the calendar month the bucket starts, leading with zero, if applicable. For example, 01
  • %scmm: A two digit number representing the calendar month, taken from the date when the bucket starts, leading with zero, if applicable. For example, 03
  • %scmmm: Three letter code representing the calendar month, considered from the date when the bucket starts. For example, Mar
  • %scyy: A two digit number representing the calendar year, considered from the date the bucket starts, leading with zero, if applicable. For example, 20
  • %scyyyy: A four digit number representing the calendar year, considered from the date the bucket starts. For example, 2020.
  • %ecd: A two digit number representing the day of the calendar month when the bucket ends. For example, 31
  • %ecmm: A two digit number representing the calendar month, considered from the date when the bucket ends, with leading zero if applicable. For example, 03.
  • %ecmmm: A three letter code representing the calendar month, considered from the date when the bucket ends. For example, Mar.
  • %ecyy: A two digit number representing the calendar year, considered from the date when the bucket ends, with leading zero if applicable. For example, 20.
  • %ecyyyy: A four digit number representing the calendar year, considered from the date when the bucket ends. For example, 2020.

These format variables are allowed at all calendar levels. Validation ensures duplicate buckets cannot be created across levels.

By default, this feature is enabled. No additional role or privilege is required to access this feature. This feature is available to those users with access to configure calendars.