Iso week date vs year

1

Hi, I have a date column and would like to add a week and year column, based on this. So I use the ‘Make date/time columns’ action.
image

But… what happens now; i see that there is the option to add a iso week number, but the year cannot be calculated with the iso method. So what happens, is that something reported on 1 2 and 3 January 2021, will be translated as iso week number = 53 , and the year is 2021… I would expect the year to be 2020.

image

Any suggestions on how to deal with this?

2

Already have my answer :slight_smile:
First i convert the date to ''week start"
image
Next action is to create the week and year from that date.
Problem solved!

1 Like