Hi Guys, Does anyone know how to generate the correct week numbers across different years? An example would be that week 53 in 2020 spans from 28 Dec 2020 - 3 Jan 2021. Extracting date & time fields would give you week 53 between 28 Dec - 31 Dec 2020 and week 1 from 1 Jan 2021 - 3 Jan 2021 in my example. The epoch calendar( Week Numbers for 2020 ) would give you week 1 as 4 Jan 2021 - 10 Jan 2021. Knime presents 4 Jan 2021 - 10 Jan 2021 as week 2 which is incorrect. Any ideas on how to align these with the correct numbers without manual manipulation for each year individually? Thanks in advance.

Oh sorry my bad. In that case this is what I get [sol] [image] daniel_weikert/generate iso week number contains 1 item Maybe you want to try this and see whether it fits your needs Hope that helps br and take care

How to generate the correct week number for every year

KNIME Analytics Platform

aworker January 14, 2022, 10:03am 2

Hi @Albert123

Maybe the following link is the solution:

Hope it helps.

Best

Ael

1 Like