Time Dimension formatting

Triannual formats is fixed to yyyyTt (e.g. 2016T2).

Formats is dependent on language, e.g name of month or day/week day.

Quarter Formats

• q (e.g. 1).
• Qq (e.g. Q1).
• yyyyQq (e.g. 2015Q1).

Month Formats

• mm (e.g. 01).
• yyyymm (e.g. 201501).
• yyyyMmm (e.g. 2015M01).
• yyyy-mmm (e.g. 2015-jan).
• yyyy-mmmm (e.g. 2012-january).

Week Formats

• week-ww (e.g. Week-01).
• yyyyww (e.g. 201501).
• yyyy-Www (e.g. 2015W01).

Day Formats

• d (e.g. 1).
• dd (e.g. 01).
• dd.mm.yyyy (e.g. 01.01.2015).
• dddd dd (e.g.  sunday 01).
• dddd dd.mm.yyyy (e.g. thursday 01.01.2015).
• dddd mm/dd/yyyy (e.g. thursday 01/01/2015).
• mm/dd/yyyy (e.g. 01/01/2015).
• yyyymmdd (e.g. 20150101).
• yyyy-mm-dd (e.g. 2015-01-01).

Weekday Formats

• wd (e.g. 0).
• wddd (e.g. sun).
• wdddd (e.g. sunday).

Custom formats

In addition to the built in formats listed above, you specify your own formats using following rules:

• Custom formats must start with '
• You can combine  the following format codes with your own characters (lower case):
• Year: yy (e.g.15), yyyy (e.g.2015).
• Triannual: t (e.g. 1).
• Quarter: q (e.g. 1).
• Month: m (e.g. 1), mm (e.g. 01), mmm (e.g. jan), mmmm (e.g. january).
• Week: w (e.g. 1), ww (e.g. 01).
• Day: d (e.g. 1), dd (e.g. 01), ddd  (e.g. sun), dddd (e.g. sunday).
• Week day: wd (e.g. 0), wddd  (e.g. sun), wdddd (e.g. sunday).
• The format codes must follow the natural hierarchy:
• Year can use year formats
• Quarter can use year and quarter formats.
• Month can use year, triannual and quarter formats.
• Day can use all formats.
• Weekday can only use weekday formats.
• The resulting text should not exceed 50 characters.

Samples:

• 'yy-mm dddd                  -> 15-01 thursday
• 'Yyy Tt Qq Mmm Ddd     -> Y15 T1 Q1 M01 D01