|
Time Intervals Formatting Macros
When editing a time interval formatting mask via the Formatting Mask dialog, the following macros can be utilized. A time interval macro displays in the Formatting Mask field after you click the arrow button to the right and select the corresponding time interval from the drop-down list. For example, if you select "Calendar Year, 4 digits" from the time intervals drop-down list, "&[year]" displays in the Formatting Mask field.
|
Macro |
Meaning |
Description |
Range |
|
dayname |
day of the week |
Localized full day name, e.g., "Wednesday". |
|
|
dayofyear |
3-digit day of year |
Day number of day in calendar year. |
001-366 |
|
dd |
2-digit calendar day |
The calendar day. |
01-31 |
|
fdayofyear |
3-digit day of fiscal year |
Day number of day in fiscal year. |
001-371 |
|
fendyear |
4-digit fiscal year |
The fiscal year expressed as the 4-digit calendar year of the last day of the fiscal year in which the date falls. |
1601-2400 |
|
fendyy |
2-digit fiscal year |
The fiscal year expressed as the 2-digit calendar year of the last day of the fiscal year in which the date falls. |
00-99 |
|
fhalfyear |
1-digit fiscal half-year |
The fiscal half-year in which the date falls. |
1-2 |
|
fperiod |
2-digit fiscal period |
The fiscal period. Either a calendar month or a 4- or 5-week period, depending on the type of fiscal year. |
01-13 |
|
fqtr |
1-digit fiscal quarter |
The fiscal quarter in which the date falls. |
1-4 |
|
fstartyear |
4-digit fiscal year |
The fiscal year expressed as the 4-digit calendar year of the first day of the fiscal year in which the date falls. |
1601-2400 |
|
fstartyy |
2-digit fiscal year |
The fiscal year expressed as the 2-digit calendar year of the first day of the fiscal year in which the date falls. |
00-99 |
|
fweek |
2-digit fiscal week number |
The fiscal week number in which the date falls. |
01-53 |
|
halfyear |
1-digit calendar half-year |
The calendar half-year in which the date falls, where each half-year is defined as six calendar months. |
1-2 |
|
isodayofyear |
3-digit day of ISO year |
Day number of day in the ISO8601 year. |
001-371 |
|
isoweek |
2-digit ISO8601 week number |
The ISO week in which the date falls. |
01-53 |
|
isoweekday |
1-digit ISO8601 day number |
The day of the week according to ISO8601: 1=Monday, 2=Tuesday, 3=Wednesday, 4=Thursday, 5=Friday, 6=Saturday, 7=Sunday. |
1-7 |
|
isoyear |
4-digit ISO8601 year |
The year corresponding to the ISO week in which the date falls. For dates at the end of December or the start of January this might be different than the calendar year. |
1601-2400 |
|
mm |
2-digit calendar month |
The calendar month. |
01-12 |
|
monthname |
name of the month |
Localized full name of the calendar month, e.g., "January". |
|
|
qtr |
1-digit calendar quarter |
The calendar quarter in which the date falls, where each quarter is defined as three calendar months. |
1-4 |
|
shortdayname |
short day of the week |
Localized short day name, e.g., "Wed". |
|
|
shortmonthname |
short name of the month |
Localized short name of the calendar month, e.g., "Jan". |
|
|
week |
2-digit calendar week number |
The week number. |
00-53 |
|
year |
4-digit calendar year |
The calendar year. A synonym for "yyyy". |
1601-2400 |
|
yy |
2-digit calendar year |
The calendar year. |
00-99 |