The node shifts a date or time with a defined duration or granularity. The user can select the Date&Time columns to shift and the shift value. The shift value can be achieved by using either a duration column or a numerical column, however, it is also possible to enter a constant shift value (either duration or numerical combined with a granularity). If the shift value is positive, it is added to the selected date. A negative value will be subtracted. A numerical value is interpreted based on the selected granularity (year, month, week, day, hour, minute, second, millisecond, nanosecond).
Options
Column Selection
Replace/Append Selection
Use Duration
Use Numerical
Popular Predecessors
- String to Date&Time14 %
- Create Date&Time Range10 %
- Date&Time Shift6 %
- GroupBy4 %
- Joiner3 %
- Math Formula3 %
Row Filter (deprecated)3 %- Rule Engine3 %
- Column Filter2 %
- Column Expressions (legacy)2 %
- Date&Time Difference2 %
- String Manipulation2 %
- Modify Date2 %
Column Rename1 %- Rule-based Row Filter1 %
- Date&Time Part Extractor1 %
Variable to Table Row1 %- Date&Time to String1 %
- Missing Value1 %
Table Row to Variable1 %String To Number1 %- Modify Time1 %
- Cross Joiner< 1 %
- Table Creator< 1 %
- String to Number< 1 %
- Generic Loop Start< 1 %
Row Splitter (deprecated)< 1 %- Date&Time-based Row Filter< 1 %
- Column Resorter< 1 %
- Rule-based Row Splitter< 1 %
- Reference Column Filter< 1 %
- Excel Reader< 1 %
- Constant Value Column< 1 %
- Date&Time Configuration< 1 %
- Concatenate< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Group Loop Start< 1 %
- DB Reader< 1 %
- String to Date/Time (legacy)< 1 %
- Number to String< 1 %
- Date&Time Input (legacy)< 1 %
- Table Row to Variable Loop Start< 1 %
- Modify Time Zone< 1 %
- Variable to Table Column< 1 %
- Sorter< 1 %
- Loop End< 1 %
- Counting Loop Start< 1 %
- DB Query Reader< 1 %
Loop End< 1 %- String to Duration< 1 %
- Variable to Table Row< 1 %
Database Connection Table Reader< 1 %- Duplicate Row Filter< 1 %
Variable to Table Column< 1 %Number To String< 1 %- Date&Time Widget< 1 %
- Math Formula (Variable)< 1 %
Recursive Loop Start< 1 %- UNIX Timestamp to Date&Time< 1 %
- Interval Loop Start< 1 %
- Reference Row Filter< 1 %
- Variable Creator< 1 %
Counting Loop Start< 1 %- Table Transposer< 1 %
- Time to String (legacy)< 1 %
- Column Appender< 1 %
- Column Renamer< 1 %
Database Writer< 1 %- Math Formula (Multi Column)< 1 %
- Rank< 1 %
Table Column to Variable< 1 %Generic Loop Start< 1 %- Nominal Value Row Filter< 1 %
- Pivot< 1 %
- RowID< 1 %
- Integer Input (legacy)< 1 %
- Rule Engine Variable< 1 %
Excel Reader (XLS)< 1 %- Filter Apply Row Splitter< 1 %
- Row Sampling< 1 %
- Lag Column< 1 %
- Chunk Loop Start< 1 %
- Moving Aggregator< 1 %
Interval Loop Start< 1 %Cell Replacer< 1 %- Extract Table Spec< 1 %
- Time Generator (legacy)< 1 %
Table Row to Variable< 1 %- Column List Loop Start< 1 %
- Cell Splitter< 1 %
- Column Combiner< 1 %
- String Replacer< 1 %
- Table Row to Variable< 1 %
- File Reader< 1 %
- Recursive Loop End< 1 %
- Recursive Loop Start< 1 %
- Table Manipulator< 1 %
- Files/Folders Meta Info< 1 %
- Integer Slider Configuration< 1 %
- Python Script (legacy)< 1 %
- SharePoint Online List Reader< 1 %
- Reference Row Splitter< 1 %
- Java Snippet< 1 %
Concatenate (Optional in)< 1 %- Column Auto Type Cast< 1 %
- Column Merger< 1 %
- Double to Integer< 1 %
Joiner< 1 %- Partitioning< 1 %
- Number Rounder< 1 %
- Ungroup< 1 %
- End IF< 1 %
- Timer Info< 1 %
- Counter Generation< 1 %
- One Row to Many< 1 %
- Time Series Generator< 1 %
- Python Source (legacy)< 1 %
- Date&Time to legacy Date&Time< 1 %
Extract Date&Time Fields< 1 %- Cell Splitter By Position< 1 %
- Column Aggregator< 1 %
- Nominal Value Row Splitter< 1 %
- String Manipulation (Variable)< 1 %
- Top k Row Filter< 1 %
- Unpivot< 1 %
- IF Switch< 1 %
- Random Number Assigner< 1 %
- Variable Expressions (legacy)< 1 %
- Integer Configuration< 1 %
- Integer Widget< 1 %
- Parameter Optimization Loop Start< 1 %
- Date/Time Shift (legacy)< 1 %
- Moving Average< 1 %
- Table Column to Variable< 1 %
- CSV Reader< 1 %
- Table Reader< 1 %
- String to Number (PMML)< 1 %
- String Manipulation (Multi Column)< 1 %
- CASE Switch Start< 1 %
- Empty Table Switch< 1 %
- Merge Variables< 1 %
- Date Extractor< 1 %
- DB Connection Closer< 1 %
- Column Splitter< 1 %
- Value Lookup< 1 %
IF Switch (Flow Variable Value)< 1 %- Wait...< 1 %
- Extract Variables (Data)< 1 %
Column Appender< 1 %- Java Edit Variable< 1 %
Cell Splitter< 1 %- DB Delete (Table)< 1 %
- Number to String (PMML)< 1 %
- Path to String (Variable)< 1 %
CSV Reader< 1 %Table Reader< 1 %- Numeric Row Splitter< 1 %
- Statistics< 1 %
- Inject Variables (Data)< 1 %
- Auto-Binner< 1 %
- Case Converter< 1 %
- Row Filter (Labs)< 1 %
Merge Variables< 1 %- Double Input (legacy)< 1 %
Python Script (1⇒1)< 1 %Flow Variable IF Switch< 1 %- String Configuration< 1 %
- JSON to Table< 1 %
- Window Loop Start< 1 %
Table Row To Variable Loop Start< 1 %Database Update< 1 %- Normalizer< 1 %
- Data Generator< 1 %
Excel Reader (XLS)< 1 %- Extract Duration Fields< 1 %
- URL to File Path (Variable)< 1 %
Recursive Loop End (2 ports)< 1 %Recursive Loop End< 1 %- Regression Predictor< 1 %
- Add Empty Rows< 1 %
- One to Many< 1 %
- Table Validator< 1 %
- Set Operator< 1 %
- Line Plot (JavaScript)< 1 %
- Slider Widget< 1 %
- Duration to Number< 1 %
- Date Field Extractor (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Extract System Properties< 1 %
- Domain Calculator< 1 %
- Salesforce Simple Query< 1 %
- URL to File Path< 1 %
Database Reader< 1 %File Reader< 1 %Table Writer< 1 %- Column Rename (Regex)< 1 %
- Cache< 1 %
- Java Edit Variable (simple)< 1 %
- Single Selection (legacy)< 1 %
- Create Collection Column< 1 %
- Active Branch Inverter< 1 %
Variable to Table Column< 1 %Table Column to Variable< 1 %Table Column to Variable< 1 %Variable to Table Row< 1 %- Loop End (Column Append)< 1 %
- Table Validator (Reference)< 1 %
- Extract Missing Value Cause< 1 %
- Missing Value Column Filter< 1 %
- Value Counter< 1 %
- Rule Engine (Dictionary)< 1 %
- Java Snippet (simple)< 1 %
- Java Snippet Row Filter< 1 %
- Google Sheets Reader< 1 %
- Nominal Row Filter Configuration< 1 %
- Slider Input (legacy)< 1 %
- String Input (legacy)< 1 %
JSON Reader< 1 %- Time Difference (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- Twitter Timeline (legacy)< 1 %
- Channel History< 1 %
- Table Writer< 1 %
- Create Table Structure< 1 %
- Constant Value Column Filter< 1 %
CASE Switch Variable (Start)< 1 %- Parquet Reader< 1 %
- Parameterized DB Query Reader< 1 %
- Gaussian Distributed Assigner< 1 %
- TimeDelay Loop Start< 1 %
- Column Filter Configuration< 1 %
- Double Configuration< 1 %
- Column Selection (legacy)< 1 %
- String Widget< 1 %
- Column Selection Widget< 1 %
- XPath< 1 %
Views
- This node has no views
Workflows
00 Data GenerationKNIME Hub- 00 Main MenuKNIME Hub
- 00 Main MenuKNIME Hub
00_xplan sf dbconv-insert via xport-AccountKNIME Hub- 004_Asset_Utilization_pigrecoKNIME Forum
- Show all 495 workflows
Links
- Subtraction between a date and a numberby izaychik63 on 2020-06-04forum.knime.com/p/93402
- Getting calendar for past 3 years from current month/year.by armingrudd on 2020-07-22forum.knime.com/p/97679
- Loop until previous date is not weekends and holidaysby JanDuo on 2020-08-26forum.knime.com/p/100780
- Selenium Send Key node: Using flow variables for text to enterby qqilihq on 2019-02-28forum.knime.com/p/55386
- I am doing a project and I have a quick questionby izaychik63 on 2020-11-03forum.knime.com/p/107135
- Show all 7 links
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.