The week_date functions in Spectre and Integrator are a very specific way to define weeks in your data based on the ISO 8601 standard. On the other hand, ProDiver's calendar date roll-up deals with fiscal calendars, which do not adhere to the ISO 8601 standard week.
Most often, creation of an external file containing various time periods used within a data set proves to be the more accurate and flexible way to handle dates.
For example, a file may include these columns to define relationships pertinent to the business:
- Date
- Week
- Month
- Period
- Quarter
- Week Beginning Date
- Week Ending Date
When considering how to work with dates, note the following:
- ISO (week_date function )
- The week begins with a Monday and ends with Sunday where the weekday number runs from 1 through 7.
- The definition for week 01 within a year is the week with the year's first Thursday in it.
- ISO standard does not define any association of weeks to months.
- ProDiver (Calendar Date Roll-up )
- The week begins on a specific day defined by the user.
- The definition for week 01 within a year is based on the starting date for the year defined by the user.
- ProDiver calendars do define an association of weeks to months (for example, 4-4-5, 4-5-4, 5-4-4).
- Date Roll-up cannot be used to define an ISO 8601 standard week.
- Date Roll-up can be used to define a fiscal calendar.
See also: