Change starting day of the week

Hello all! I am hoping someone can assist, i am trying to change the starting day of the week from Sunday to Thursdays. I was trying to follow the following instruction guide from perplexity but keep getting an error where the math formula node will not see the newly created column from Extract date & time node.

I get a warning box pop up with the following message. "Invalid settings: No such column: Date

Any suggestions would be greatly appreciated as search history on changing the start of the week in knime seems limited for this specific type scenario. See below for the instructions I was following.

To create a new date column for week numbers based on a Thursday to Wednesday schedule from your existing Sunday to Saturday schedule in KNIME, you can follow these steps:

  1. Use the “Extract Date&Time Fields” node to extract the day of the week from your existing date column.

  2. Add a “Math Formula” node to shift the dates to align with the Thursday to Wednesday schedule:

text

$Date$ + (4 - MOD($DayOfWeek$ + 7 - 1, 7))

This formula adjusts the date to the nearest Thursday1.

  1. Use another “Extract Date&Time Fields” node on the shifted date column to extract the new week number.

  2. If needed, use a “Column Rename” node to rename the new week number column appropriately.

This approach will effectively recalculate your week numbers based on a Thursday to Wednesday schedule. The key is shifting the dates so that Thursday becomes the first day of the week, then extracting the week number from these adjusted dates