🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

[SOLVED] Create calendar week out of date (German definition of calendar week)

User: "Sylvia"
New Altair Community Member
Updated by Jocelyn
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

Find more posts tagged with