Icon

251021_​Calenderweek

String to Date & Time does not convert - KNIME Analytics Platform - KNIME Community Forum

I need to perform an analysis of receiving data which includes the year and the week of the receiving data in the format yyyyww.

Following steps have been done so far:

  • transform data from number to string (number to String Node)

  • separated year and week with the String manipulation node and added a W to the number of the week and a -1 to create a day in the week (recommended hint by MS Copilot)

    • substr($Lieferwoche$, 0, 4) + “-W” + substr($Lieferwoche$, 4, 2) + “-1”

  • Than tried to create the date column but failed

I have been asking the KNIME-AI and MS Copilot but none of the hints could solve the problem. I have attached a file with some more details.

It would be great if somebody could help me out

Round to First Day of Week
Date Rounder
Shift Date
Date Shifter
Create Dummy Date
String Manipulation
String to Date&Time
Date&Time Part Extractor
Date&Time Part Extractor
Convert to Date Datetype
String to Date&Time
Table Creator
Adjust number of weeks to add
Math Formula
Extract Year/Week
Cell Splitter
Nicer Names
Column Renamer
Expression
Table Creator

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: andi_KNIME
Created at: 2025-10-21
On NodePit since: 2025-10-21
Last update: 2025-10-22
Created with KNIME version: v5.8.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!