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

 

 

 

 

© 2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support