Today the extract() function does not support extracting the ‘week number’ from a date field. As a workaround you can use a formula like this (may need some adjustments +/-1 for certain years, could add some ifElse logic to account for that). FYI this uses weeks starting Sun. dateDiff(truncDate("WK…

Nice, that helped a lot! For the week starting on Monday: ifelse( extract("WD", Date) = 1, dateDiff(truncDate("WK", truncDate('YYYY', Date)), Date, 'WK'), dateDiff(truncDate("WK", truncDate('YYYY', Date)), Date, 'WK')+1 ) This can be changed to any day of the week can be used as start…

Week Numbers (1-53)

Learning Center Articles

Jesse February 14, 2023, 8:37pm 8

There’s also this page but I dont think you can subscribe to it:

Min & Max Dates for a 'Week Number' in a Pivot Table Row

formatDate() gives me an error about unsupported format

Error periodOverPeriodLastValue periodo week