The ISO-8601 week-based calendar doesn’t use months. The last quarter has either 13 weeks (in a short year) or 14 weeks (in a long year). The first three quarters in the ISO-8601 always have 13 weeks. Each ISO-8601 year is either a long or a short year, with 52 or 53 weeks, depending on when the ISO-8601 year begins. This can cause some discrepancy in years between the two calendar systems around those dates. Gregorian calendars always start the year on January 1. This means the year may start anywhere between December 29 and January 4. ISO-8601 years always start on the first Monday closest to January 1. Not all date levels are relevant in a fiscal calendar. Differences between ISO-8601 and Standard Gregorian calendars In the shelf, right-click a date dimension (Ctrl-click on Mac), and select ISO-8601 Week-Based. Set the Default calendar field to ISO-8601 Week-based.įor each date field on the shelf, you can set the calendar type separately.Right-click (control-click on Mac) the data source in the Data pane to open the Date Properties dialog box. To set the ISO 8601 calendar for a data source, follow these steps: This makes the ISO-8601 calendar popular when calculating retail and financial dates. Unlike the Gregorian calendar, ISO-8601 calendars have a consistent number of weeks in each quarter and a consistent number of days each week. ISO-8601 calendars divide dates into years, quarters, weeks, and weekdays. The purpose of the ISO-8601 calendar is to provide a consistent and clear method to represent and calculate dates. The ISO-8601 Week-Based Calendar is an international standard for date-related data.
0 kommentar(er)
