[SOLVED] Create calendar week out of date (German definition of calendar week)
Hello,
I'd like to analyze the number of contracts by calendar week based on a data extract which shows all contracts including the date of contract creation. The output table should include the number of created contracts grouped by product group, calendar week and year.
I transformed the contract creation date to calendar week using the operator "Date to Numerical" (time unit = week, week relative to year). Unfortunately the calendar week is generated based on the definition used in the US meaning that Sunday is the first day of a week. Is it possible to change the default settings so that the calendar week is generated according to the German definition (Monday is the first day of a week, each week has seven days, for the calendar week end of December / beginning of January the Thursday indicates to which year the calendar week belongs).
Thanks
Sylvia
I'd like to analyze the number of contracts by calendar week based on a data extract which shows all contracts including the date of contract creation. The output table should include the number of created contracts grouped by product group, calendar week and year.
I transformed the contract creation date to calendar week using the operator "Date to Numerical" (time unit = week, week relative to year). Unfortunately the calendar week is generated based on the definition used in the US meaning that Sunday is the first day of a week. Is it possible to change the default settings so that the calendar week is generated according to the German definition (Monday is the first day of a week, each week has seven days, for the calendar week end of December / beginning of January the Thursday indicates to which year the calendar week belongs).
Thanks
Sylvia