The node shifts a date/time with a defined granularity. The user can select the date reference and the shift value. The date can be chosen as a Date/Time column, as the execution time or as a fixed entered date. The shift value can be achieved by using a numerical column, however, it is also possible to enter a constant shift value. The numerical shift value is added to the selected date. The value is interpreted based on the selected granularity (year, quarter, month, week, day, hour, minute).
Options
Popular Predecessors
Double To Int3 %Counting Loop Start3 %- Timer Info2 %
Excel Reader (XLS)2 %- String to Date/Time (legacy)2 %
- Shuffle2 %
- Empty Table Creator2 %
- String to Date&Time2 %
- GroupBy2 %
String To Number2 %- Concatenate2 %
Row Splitter (deprecated)2 %- Rule-based Row Splitter2 %
Excel Reader (XLS)2 %- Double to Integer1 %
- Reference Row Filter1 %
- Mask Date/Time (legacy)1 %
- Date&Time Difference1 %
Table Row To Variable Loop Start1 %- Constant Value Column1 %
- Rule-based Row Filter1 %
- Date&Time to String1 %
- Date&Time to legacy Date&Time1 %
- Date&Time Shift1 %
- Modify Date1 %
- Date Field Extractor (legacy)1 %
- Preset Date/Time (legacy)1 %
- Missing Value< 1 %
- Math Formula (Variable)< 1 %
- Time Generator (legacy)< 1 %
- Add Empty Rows< 1 %
- Lag Column< 1 %
- Column Filter< 1 %
- Pivot< 1 %
Column Rename< 1 %- Integer Input (legacy)< 1 %
- Number to String< 1 %
- String to Number< 1 %
- Joiner< 1 %
- DB Reader< 1 %
- Date&Time Part Extractor< 1 %
Table Row to Variable< 1 %- Table Creator< 1 %
Interval Loop Start< 1 %Row Filter (deprecated)< 1 %- Sorter< 1 %
- String Manipulation< 1 %
- Rule Engine< 1 %
- Math Formula< 1 %
- Java Snippet (simple)< 1 %
- Date&Time Input (legacy)< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Create Date&Time Range< 1 %
- Date/Time Shift (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Moving Average< 1 %
- Column Expressions (legacy)< 1 %
- Variable to Table Row< 1 %
- CSV Reader< 1 %
- Excel Reader< 1 %
- Table Manipulator< 1 %
Table Reader< 1 %- Group Loop Start< 1 %
- Column Auto Type Cast< 1 %
Joiner< 1 %- Random Matcher< 1 %
- Math Formula (Multi Column)< 1 %
XLS Reader< 1 %- Column Combiner< 1 %
- Nominal Value Row Splitter< 1 %
- Modify Time< 1 %
Database Connection Table Reader< 1 %Database Reader< 1 %Concatenate (Optional in)< 1 %- Column Aggregator< 1 %
- Time to String (legacy)< 1 %
- Cell Splitter< 1 %
- Row Sampling< 1 %
- Wait...< 1 %
CSV Reader< 1 %File Reader< 1 %- Java Snippet< 1 %
Loop End< 1 %- Chunk Loop Start< 1 %
Recursive Loop Start< 1 %Cell Splitter< 1 %- Column Renamer (Dictionary)< 1 %
- Column Resorter< 1 %
- Partitioning< 1 %
- Rank< 1 %
- Ungroup< 1 %
CASE Switch Variable (Start)< 1 %- IF Switch< 1 %
Merge Variables< 1 %- Conditional Box Plot (legacy)< 1 %
- Color Manager< 1 %
- Counter Generation< 1 %
- TimeDelay Loop Start< 1 %
- JSON Path< 1 %
- R Snippet< 1 %
- Time Field Extractor (legacy)< 1 %
- XPath< 1 %
Variable to Table Row< 1 %Database Column Rename< 1 %- Column List Loop Start< 1 %
Scorer< 1 %- Case Converter< 1 %
- Column Splitter< 1 %
- JSON to Table< 1 %
- Python Edit Variable (legacy)< 1 %
- String to Duration< 1 %
- Extract Duration Fields< 1 %
- Modify Time Zone< 1 %
- Generic Web Service Client< 1 %
- Block Programmatically (Table)< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Catch Errors (Data Ports)< 1 %
Variable to Table Row< 1 %- Java Edit Variable< 1 %
Loop End (2 ports)< 1 %Loop End (Column Append)< 1 %- Decision Tree Predictor< 1 %
Cell Replacer< 1 %Number To String< 1 %- Column Name Extractor< 1 %
- Column Merger< 1 %
- Column Rename (Regex)< 1 %
- One to Many< 1 %
- Cross Joiner< 1 %
- Nominal Value Row Filter< 1 %
- String Splitter (Regex)< 1 %
- Number Rounder< 1 %
- String Manipulation (Variable)< 1 %
- String Replacer< 1 %
- Table Transposer< 1 %
- Rule Engine Variable< 1 %
CASE Switch Data (End)< 1 %- End IF< 1 %
- Parallel Chunk Start< 1 %
- One Row to Many< 1 %
- Random Label Assigner< 1 %
SAS7BDAT Reader< 1 %- Java IF (Table)< 1 %
- Java Snippet Row Splitter< 1 %
- POS Tagger< 1 %
Date Input (legacy)< 1 %- String Input (legacy)< 1 %
Python Edit Variable< 1 %- R Source (Table)< 1 %
- Time Difference (legacy)< 1 %
- Twitter Retweet Search (legacy)< 1 %
Flow Variable IF Switch< 1 %- Table Row To Variable Run-for-time Loop Start< 1 %
- Table Row To Variable Run-to-time Loop Start< 1 %
- Extract Variables (Data)< 1 %
- Inject Variables (Data)< 1 %
Table Row to Variable< 1 %Database Update< 1 %Database Looping< 1 %Generic Loop Start< 1 %- Numeric Scorer< 1 %
- Column to Grid< 1 %
- Missing Value Column Filter< 1 %
- String to Number (PMML)< 1 %
- RowID< 1 %
- Statistics< 1 %
- Crosstab< 1 %
- Box Plot (legacy)< 1 %
- DB Query Reader< 1 %
- Time Series Generator< 1 %
Excel Reader (XLS)< 1 %- Java Edit Variable (simple)< 1 %
- Case Converter< 1 %
Strings To Document< 1 %- Date&Time Configuration< 1 %
- Value Filter (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Scatter Plot (JavaScript)< 1 %
Integer Input (legacy)< 1 %- R to Table< 1 %
- UNIX Timestamp to Date&Time< 1 %
Extract Date&Time Fields< 1 %- Date&Time-based Row Filter< 1 %
- Window Loop Start< 1 %
- Table Row to Variable< 1 %
- Duplicate Row Filter< 1 %
- Row Splitter (Labs)< 1 %
- Unpivot< 1 %
Views
- This node has no views
Workflows
(Optional)_Linear_RegressionKNIME Hub- 2017_01_23_WindGustKNIME Hub
- ChallengeKNIME Hub
- End of month dateKNIME Forum
- First and Last of MonthKNIME Forum
- Show all 12 workflows
Links
- No links available
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.