Icon

1. Date & Time Manipulation

<p><strong>Date &amp; Time Manipulation</strong></p><p>This workflow shows:</p><ul><li><p>how to generate Date&amp;Time objects (columns) from String columns,</p></li><li><p>how to generate a Date&amp;Time series artificially, and</p></li><li><p>a few Date&amp;Time manipulation nodes, to modify and shift Date&amp;Time vlaues back and forth in time.</p></li></ul>

Workflow: Date & Time Manipulation


This workflow shows:

  • how to generate Date&Time objects (columns) from String columns,

  • how to generate a Date&Time series artificially, and

  • a few Date&Time manipulation nodes, to modify and shift Date&Time vlaues back and forth in time.

Create time range

Writing data

Date & Time conversions

Modify Date & Time values

Reading data

Change time stampto fixed time asdd.mm.yyyy 15:00
Time Modifier
Move all Date&Time valuesforward by one day (+1 d)
Date Shifter
sales.csvin KALdata folder
CSV Reader
Write tonew_sales.csv file
CSV Writer
Generates a sequence ofequally spaced dates between01.01.2023 and 01.01.2025
Date&Time Range Creator
Convert String column "date"to a Date column
String to Date&Time
Convert Date column "date"back to a String column
Date&Time to String

Nodes

Extensions

Links