{"title":"Date Shifter","nodeType":"Manipulator","id":"*TRyzM68BPCPSFm2H","factoryName":"org.knime.time.node.manipulate.datetimeshift.DateShiftNodeFactory","factoryId":"org.knime.time.node.manipulate.datetimeshift.DateShiftNodeFactory","path":["Other Data Types","Time Series","Manipulate"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Shifts date columns by a defined duration or granularity. You can select the date columns to shift and specify the shift value as a duration column, a numerical column with a granularity, or a constant numerical value with a granularity. Positive values shift the date forward; negative values shift it backward. Numerical values are interpreted based on the selected granularity.\n <br />\n Often used to adjust timestamps to account for time zone differences or reporting durations.</p>\n        ","shortDescription":"Shifts a date by a duration or granularity.","keywords":["date","time","shift","modify","fields","day","month","week","year"],"deprecated":false,"streamable":true,"tags":["Other Data Types","Time Series","Manipulate","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAYAAABXAvmHAAAACXBIWXMAACE4AAAhOAFFljFgAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAALDSURBVHgB7Zm9b5JBHMe/90BdpKjb08jAYBcmYPEZEJlIrYuJYONkgTQOaqCbjdWmiSaOJepcNwP6D5SJ2DbFRVyKAw4MJDgaYKNw3j1NeZG35+Gh4Xns80mecBx35Pe9+73cAWBiYmIySwg04pOkABHg5O1GC9lcLlcaNT4gSc6mgABv0xZKB7lcFhqwQiMCwSpbh0e8PSfQCHv5OGo8N56A7MpvLISPzUID7R2QV8YibEElpEUD7FucvE0pM0YgpdEzqJPQ0x1glCghWaik0Wxtn+10eweaFrJLKDNGLV1OSAgzjKlQARNDV6GSSwKusZd7vC3AgLA1unLWHhgDkWgM4sIC9ESxWMSXdKqvf6AAt9cLt8cDPSHmvw8UYEgX6sbwAhTVgfjTJ/iRz/f0Ld1ZxsbmJmaN5kLGqVareLy2hmkhSRLi6+uKxk5NACssmBbXHQ7FYy9GDIzDbrfjUyoFLeSOjpDc2YFaFAnw+f0Qxd7C5vF26gQXwP1WC+VyGZOgSED4wQrOi0KhIMfQz+Pjdl+tK6ZcLpe8QMOYigtpIbO31+c6mUxGfhwsmPcPD0fOn3kQR2OxoSscTyTGTZ+9AG78y63+a8j9UAihcHjsfF2k0RAz9uY/SSAxzUL2YuM5frHjbDe+W348i8cHjn+XTOJg/2tPn9vtGXn04AY/XDlNFtytHAqLmSIB/Ghtu2zr6VtcvDF0PP+sXqv19I27X/A0zN3mG8s+kWgUSjmXNLq0fFd+1PKKxQJPnw6jHiV4QAeDQVVzzLPQNPicTvddF0VRRPL9h7FzdSGAB/zvSgWToJs0Oim6SaOToqs0Ogm6iAG+Y/xHgm5s8/OK5upCgM9/W34m4f+sAxWW0nge1hP1en1g/0ABb9+8hlHouBDFHxiQzh8cjZNt65zVyYRchY6hoKXmSVPZbcfExET//AWUz9aw6WRBbgAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table","description":"Input table containing date&amp;time columns."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output table","description":"Output table with shifted date."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Date&time columns","description":"The date&amp;time columns whose values are shifted.","optional":false},{"name":"Shift mode","description":"Select the shift mode to use.\n<ul><li><b>Shift value</b> : Uses a date-based shift value.</li><li><b>Duration column</b> : Uses a shift value from a date-based duration column.</li><li><b>Number column</b> : Uses a numerical column to scale a configurable time unit.</li></ul>","optional":false},{"name":"Shift value","description":"Select to insert a format string to use as constant shift value. The inserted string can be either in:\n<ul><li>the ISO-8601 representation (see <a href=\"http://docs.oracle.com/javase/8/docs/api/java/time/Period.html#parse-java.lang.CharSequence-\" rel=\"ugc nofollow noopener noreferrer\"> date-based duration format</a> for details)</li><li>the short letter representation (e.g. &#39;2y 3M 1d&#39;). In this case, for the the letters y, M, and d respectively indicate years, months, and days.</li><li>the long word representation (e.g. &#39;2 years 3 months 1 day&#39;).</li></ul>","optional":false},{"name":"Column","description":"Select to choose the shift value from a date-based duration column.","optional":false},{"name":"Column","description":"Select to choose the shift value from a numerical column. The shift value will be scaled by the selected granularity.","optional":false},{"name":"Granularity","description":"The granularity (i.e. days, weeks, etc) of the shift.","optional":false},{"name":"Output columns","description":"Depending on this setting, the output columns will either replace the modified columns, or be appended to the table with a suffix.\n<ul><li><b>Replace</b> : Replaces the selected columns by the new columns.</li><li><b>Append with suffix</b> : Appends the selected columns to the input table with a new name that is the previous name plus the provided suffix.</li></ul>","optional":false},{"name":"Output column suffix","description":"The suffix to append to the column names of the new columns.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606171548","bundleName":"KNIME Date and Time Handling","bundleSymbolicName":"org.knime.time","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[]}