Calendar

Hierarchy of Year / Quarter / Month / ISO Date / Hour

Date

2018-09-24

Day Of Month Name

Abbreviated month name followed by the day of the month

Sep-24

Month Name

Name of the month

September

Quarter

Number of the Quarter:

1 is January to March

2 is April to June

3 is July to September

4 is October to December

3

Quarter Name

Number of the Quarter:

Q1 is January to March

Q2 is April to June

Q3 is July to September

Q4 is October to December

Q3

Year

Year in YYYY

2018

Year Month

Month of one Year. Year followed by abbreviated month name.

2018 Sep

Year Quarter

Quarter of one Year. Year followed by Quarter name.

2018 Q3

Financial Period

Financial Period

Financial Period ID

Financial Period ID

Financial Year

Financial Year

Date

Date in MM/DD/YYYY

9/24/2018

Day Name

Name of the day.

Monday

Is Default Date

Values: True or False

True

Is Production Day

Values: True or False

False

Is Shipment Day

Values: True or False

True

ISO Day Of Week

Number of the day of the week. Values: 1 - 7

(1=Monday, 2= Tuesday, ..., 7= Sunday)

1

ISO Week

Number of the calendar week. Values: 1 - 53

39

ISO Year

Year in YYYY

2018

ISO Year Week

Combination of year and ISO week number

2018-W39

ISO Year Week Day

Combination of year, ISO week number and ISO Day of Week

2018-W39-1