Year 1 & 2 |
|
|
|
|
Calendar Year |
Example |
|
Financial Year |
Example |
as [yy] |
16 |
|
as [FY yy] |
FY 17 |
as [yyyy] |
2016 |
|
as [FY yyyy] |
FY 2017 |
|
|
|
as [Financial Year yy] |
Financial Year 17 |
|
|
|
as [Financial Year yyyy] |
Financial Year 2017 |
|
|
|
|
|
Halfyear 1 & 2 |
|
|
|
|
Calendar Year |
Example |
|
Financial Year |
Example |
as [hy] |
02 |
|
as [FH 0hy] |
FH 001 |
as [hy.yy] |
02.16 |
|
as [FH 0hy.yy] |
FH 001.17 |
as [hy / yy] |
02 / 16 |
|
as [FH 0hy / yy] |
FH 001 / 17 |
as [hy.yyyy] |
02.2016 |
|
as [FH 0hy.yyyy] |
FH 001.2017 |
as [hy / yyyy] |
02 / 2016 |
|
as [FH 0hy / yyyy] |
FH 001 / 2017 |
as [Halfyear hy] |
Halfyear 02 |
|
as [Financial Halfyear 0hy] |
Financial Halfyear 001 |
as [Halfyear hy.yy] |
Halfyear 02.16 |
|
as [Financial Halfyear 0hy.yy] |
Financial Halfyear 001.17 |
as [Halfyear hy / yy] |
Halfyear 02 / 16 |
|
as [Financial Halfyear 0hy / yy] |
Financial Halfyear 001 / 17 |
as [Halfyear hy.yyyy] |
Halfyear 02.2016 |
|
as [Financial Halfyear 0hy.yyyy] |
Financial Halfyear 001.2017 |
as [Halfyear hy / yyyy] |
Halfyear 02 / 2016 |
|
as [Financial Halfyear 0hy / yyyy] |
Financial Halfyear 001 / 2017 |
|
|
|
|
|
Quarter 1 & 2 |
|
|
|
|
Calendar Year |
Example |
|
Financial Year |
Example |
as [qq] |
03 |
|
as [FQ 0qq] |
FQ 002 |
as [qq.yy] |
03.16 |
|
as [FQ 0qq.yy] |
FQ 002.17 |
as [qq / yy] |
03 / 16 |
|
as [FQ 0qq / yy] |
FQ 002 / 17 |
as [qq.yyyy] |
03.2016 |
|
as [FQ 0qq.yyyy] |
FQ 002.2017 |
as [qq / yyyy] |
03 / 2016 |
|
as [FQ 0qq / yyyy] |
FQ 002 / 2017 |
as [Quarter qq] |
Quarter 03 |
|
as [Financial Quarter 0qq] |
Financial Quarter 002 |
as [Quarter qq.yy] |
Quarter 03.16 |
|
as [Financial Quarter 0qq.yy] |
Financial Quarter 002.17 |
as [Quarter qq / yy] |
Quarter 03 / 16 |
|
as [Financial Quarter 0qq / yy] |
Financial Quarter 002 / 17 |
as [Quarter qq.yyyy] |
Quarter 03.2016 |
|
as [Financial Quarter 0qq.yyyy] |
Financial Quarter 002.2017 |
as [Quarter qq / yyyy] |
Quarter 03 / 2016 |
|
as [Financial Quarter 0qq / yyyy] |
Financial Quarter 002 / 2017 |
|
|
|
|
|
Halfyear 1 & 2 |
|
|
|
|
Calendar Year |
Example |
|
Financial Year |
Example |
as [mm] |
08 |
|
as [FP ppp] |
FP 005 |
as [mmm] |
Aug |
|
as [FP ppp.yy] |
FP 005.17 |
as [mmmm] |
August |
|
as [FP ppp.yyy] |
FP 005.2107 |
as [mmm yy] |
Aug 16 |
|
as [Financial Period ppp] |
Financial Period 005 |
as [mmmm yyyy] |
August 2016 |
|
as [Financial Period ppp.yy] |
Financial Period 005.17 |
as [mm.yyyy] |
08.2016 |
|
as [Financial Period ppp.yyy] |
Financial Period 005.2017 |
as [Month mm] |
Month 08 |
|
as [FP ppp.yyyy (MMMM)] |
FP 005.2017 (August) |
as [Month mm.yy] |
Month 08.16 |
|
as [Financial Period ppp.yyyy (MMMM)] |
Financial Period 005.2017 (August) |
as [Month mm.yyyy] |
Month 08.2016 |
|
as [Financial Period ppp.yyyy (MMMM YY)] |
Financial Period 005.2017 (August 16) |
|
|
|
as [Financial Period ppp.yyyy (MMMM YYYY)] |
Financial Period 005.2017 (August 2016) |
|
|
|
|
|
Week |
|
|
|
|
Calendar Year |
Example |
|
|
|
as [ww] |
34 |
|
|
|
as [ww.yyyy] |
34.2016 |
|
|
|
as [ww / yyyy] |
34 / 2016 |
|
|
|
as [Week ww] |
Week 34 |
|
|
|
as [Week ww.yyyy] |
Week 34.2016 |
|
|
|
as [Week ww / yyyy] |
Week 34 / 2016 |
|
|
|
|
|
|
|
|
Day 1 to 6 |
|
|
|
|
Calendar Year |
Example |
|
|
|
as [dd] |
28 |
|
|
|
as [ddd] |
Su |
|
|
|
as [dddd] |
Sunday |
|
|
|
as [dd.mm.] |
28.08. |
|
|
|
as [dd.mm.yyyy] |
28.08.2016 |
|
|
|
as day of year |
241 |
|
|
|
as day of halfyear |
59 |
|
|
|
as day of quarter |
60 |
|
|
|
as day of week |
07 |
|
|
|
as day of range (with weekends) |
27 |
|
|
|
as day of range (without weekends) |
19 |
|
|
|
as day of financial year |
241 |
|
|
|
as day of financial halfyear |
059 |
|
|
|
as day of financial quarter |
060 |
|
|
|
as day of financial period |
028 |
|
|
|