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.
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.
Any suggestions on how to deal with this?